Excel - Split long column into multiple columns by empty cell

So I have data, that once imported into excel looks like this:

1
2
3
4

A
B
C
D

!
@
#
$

I want the data to look like this:

1 A !
2 B @
3 C #
4 D $

All the data is in one column, and each new set of data is offset by an empty cell. All I want to do is be able to split that one column into multiple columns, creating a new column at every empty cell. Each time I record data, there will be an equal number of data entries in each set, but they are not of the same type, and between recordings there can be different numbers of entries in each set. Basically, all I want to have happen is excel goes down the column, and when it finds an empty cell, it copies all remaining data over to the next column and then looks for the next empty cell, at which point it will do the same thing until there are 2 empty cells in a row.

Searching how to do this is extremely annoying because I keep getting text to column results, which isn't what I want.

Thanks in advance.