How to transpose a single column into individual rows based on a similar data?

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.