Questions tagged [unpivot]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
1k 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 ...
2
votes
1answer
2k 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 ...