Suppose that we have a column including a million rows like this:
12
56
35
17
130
XYZ 1
XYZ 2
3
93
55
XYZ 3
12
XYZ 4
156
83
15
12
XYZ 5
How to transpose this single column into individual rows based on a XYZ i? Like this:
XYZ 1 12 56 35 17 130
XYZ 2
XYZ 3 3 93 55
XYZ 4 12
XYZ 5 156 83 15 12
Here is a solution but I couldn't edit the code to solve my own problem:
"How to transpose variable data from column A to multiple rows"
Any help would be greatly appreciated.
Bookmarks