Separated data in one column to multiple columns

L

leenathan

Howdy Excel experts,

I have one big column of data, each chunk of values separated by a
space of blank cells. I'd like to take all the data chunks and put
them each in their own column, beginning at the top of the worksheet.
Basically taking one long column of data and transforming it into a
shorter, wider worksheet.

I hope this makes sense. Thanks for your help!
 
G

Gord Dibben

Are all chunks the same number of rows?

Are the spaces between chunks uniform?


Gord Dibben MS Excel MVP
 
Top