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.bo...@madduck.net
--
To unsubscribe e-mail to: users+unsubscr...@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