I am looking to do the following:

I want a solution or macro which will do the following:

I have data in column one but need the every other line to be cut and
pasted in column 2 one after the other then need column one empty
spaces to be deleted so data will show after the other which
corresponds with column 2.

Example:

How data comes thru now:

Data 1
Data 2
Data 1
Data 2

How I want data to show:
Data 1 Data 2
Data 1 Data 2

Thanks,
Chris