Questions tagged [unpivot]
The unpivot tag has no usage guidance.
2
questions
2
votes
1answer
3k views
Transpose Ranges repeated by row
I would like to convert several range of columns into rows, and keeping the association to the original col/row source
Sample source sheet
---------------------------------------------------
| Data ...
1
vote
1answer
2k views
Split columns in to rows in google spread sheets [duplicate]
I have following table:
ID Event Event2 Event3
102 181 182 184
103 5 7 8
I want to convert in into:
ID Event
102 181
102 182
102 184
103 5
...