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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

One big column to lots of small columns 7
Single column to multiple columns 5
How can I merge data from multiple columns into a single column in Microsoft Excel? 0
Excel Subtracting multiple columns from another column 3
One column to multiple columns 2
Changing column reference for number of formulas at once 1
One column to multiple columns - with a twist 3
correlating and summing data from multiple spreadsheets 1

Top