Excel - break one column into multiple columns

Excel - break one column into multiple columns

We have several text documents what look something like this:
4ED
Group 1: ITE-1
Group 2: ITE-2
Group 2: ITE-6
Group 2: DFG-1
7DF
Group 1: RDA-1
Group 2: ITE-2
DEF
Group 1: SIMON
Group 2: LPI
Group 2: K88TS
Group 2: HOUSE1
ZDF
Group 1: LPI
The list can be several thousand lines long and the blocks of data are
different sizes as shown.
I have been tasked with entering the data into a spreadsheet with each
block of data being a new column.
Does anyone know if it is possible to create a macro (or use an existing
Excel feature) that will be able to move each block of data to a new
column? Perhaps a rule could be created where the macro sees the blank
cell between each block then cuts and pastes the data between each blank
cell to a new column.
Sorry for rambling.