COL A has 165,000 cells that looks like this:

CONTROL-NBR 1
DATA1
DATA2
DATA3
CONTROL-NBR 2
DATA1
DATA2
DATA3
DATA4
DATA5
DATA6
CONTROL-NBR 3
DATA1
CONTROL-NBR 4
DATA1
DATA2
DATA3
DATA4
DATA5

How can I transpose the "DATA" cells for each "CONTROL-NBR" onto the
same row as the "CONTROL-NBR" so the result looks like this::

CONTROL-NBR-1 DATA1 DATA2 DATA3



CONTROL-NBR-2 DATA1 DATA2 DATA3 DATA4 DATA5 DATA6






CONTROL-NBR-3 DATA1

CONTROL-NBR-4 DATA1 DATA2 DATA3 DATA4 DATA5






(Note: The number of "DATA" cells for each "CONTROL-NBR" varies from 1
to 30).