mardi 14 janvier 2020

Transform matrix into column on google sheets

I have a number of matrixes such as:

Input Matrix

I would like to transform this data in such way, that it is resembled in one column, such as:

Output Rows

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