I have a number of matrixes such as:
I would like to transform this data in such way, that it is resembled in one column, such as:
Here is the link to a testsheet with exactly this data: https://docs.google.com/spreadsheets/d/17s9OCXh4-O8J9Jz-PNy97oSSL8vKTwBYT8Z6KD7Q6kM/edit?usp=sharing
What I have done so far: I know, that I can do this using "transpose" or "mtrans" (same thing). But unfortunately for this I will have to do it manually. I'm looking for just ONE formular to solve this problem, so I don't have to always do it manually for every row.


Aucun commentaire:
Enregistrer un commentaire