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!
Bernard Liengme - 30 Jun 2006 19:26 GMT
Use Data | Text to Columns
best wishes

Signature
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email
> Howdy Excel experts,
>
[quoted text clipped - 5 lines]
>
> I hope this makes sense. Thanks for your help!
Gord Dibben - 30 Jun 2006 21:00 GMT
Are all chunks the same number of rows?
Are the spaces between chunks uniform?
Gord Dibben MS Excel MVP
>Use Data | Text to Columns
>best wishes
[quoted text clipped - 8 lines]
>>
>> I hope this makes sense. Thanks for your help!