Combining multiple cells in a column into one cell on top of one another?

[stangz71]

Hey everyone

I have been looking everywhere on how to combine multiple cells in a column so they end up in one cell on top of one another. The script or command would also need to know when there is a space in one of the cells and stop, then start all over once the next set of data is found. The amount of cells in the column will vary.

Example:

Cell A1: data1
Cell A2: data2
Cell A3: data3

Cell A4: data4

Cell A5: data5
Cell A6: data6

Output:

B1:
data1
data2
data3

B4:
data4

B5:
data5
data6

Any assistance would be appreciated, thanks.