Separated data in one column to multiple columns

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!

Use Data | Text to Columns
best wishes

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

<[email protected]> wrote in message
news:[email protected]...
> 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


On Fri, 30 Jun 2006 15:26:48 -0300, "Bernard Liengme"
<[email protected]> wrote:

>Use Data | Text to Columns
>best wishes
>
>--
>Bernard V Liengme
>www.stfx.ca/people/bliengme
>remove caps from email
>
><[email protected]> wrote in message
>news:[email protected]...
>> 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!
>>