Re: [libreoffice-users] Consolidating values from multiple sheets

At 22:29 17/08/2021 +1200, Martin F Krafft wrote:

> I've got several sheets with values such as the following:
>
> | Thu | Fri | Sat |
> |----:|----:|----:|
>
> | 5 | 6 | | | | 9 | 10 | | 1 | | 2 | | | 9 | 10 | | 11 | | 12 | | 7 
> | 8 | | | | 3 | 4 | | 11 | | 12 |
>
>
> Here is another
>
> | Thu | Fri | Sat |
> |----:|----:|----:|
>
> | g | h | | | a | | b | | | i | j | | g | h | | | e | f | | | | c | 
> d | | k | | l |

Sorry, but I have no idea what this picture represents. It is usually 
more helpful to explain how your sheets are organs.

> How would one go about creating a new sheet that consolidates all 
> these together, so that I'd get a list of all the values for each of 
> the columns, i.e. an array with the values {5,1,11,7,11,g,a,g,e,k} 
> for "Thu", and so on, ...

Er, exactly how do those become the values for Thursday?

o Enter "=" (no quotes) into the target cell in your new sheet.
o Click the tab of your source sheet to display it.
o Click the source cell.
o Press Enter (or click the Accept green tick icon in the Input Line).

You can now drag the cell's fill handle in the target sheet to expand 
the area referenced to a row, a column, or another range.

I trust this helps.

Brian Barker


--
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy