[libreoffice-users] Consolidating values from multiple sheets

Hey,

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   |

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, and ideally without the blank lines?

Is this possible without scripting? It has to run on Excel as well 
as Calc, and I don't think scripting is a sensible way to go for 
that.

Ideally, I can also suppress duplicates *and* sort the result. Any 
ideas?

--
@martinkrafft | https://matrix.to/#/#madduck:madduck.net
 
"i can stand brute force, but brute reason is quite unbearable. there
 is something unfair about its use. it is hitting below the
 intellect."
                                                      -- oscar wilde
 
spamtraps: madduck.bogus@madduck.net

--
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