Separated data in one column to multiple columns

  • Thread starter Thread starter leenathan
  • Start date Start date
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!
 
Are all chunks the same number of rows?

Are the spaces between chunks uniform?


Gord Dibben MS Excel MVP
 
Back
Top