One column to multiple columns

[Tenacious Lee]

Hello to all Excel experts in internet-land,


I have an interesting twist on a problem that has been solved in lots
of previous posts. I have a huge column of numerical data, with
'chunks' of cells of data separated by variably-sized 'chunks' of blank
cells. I would like to be able to apply a macro that will wade through
the data, splitting the big column into multiple columns, with each
'chunk' of data in its own individual column. Hopefully this will
clarify things for you:

Raw data:

1
2
3
4


4
5
7



12
3
5
67
7

Finished product:

1 4 12
2 5 3
3 7 5
4 67
7

Any help or code snippets from a curious expert would be greatly
appreciated!

 

[Dave Peterson]

See your later post.

Hello to all Excel experts in internet-land,

I have an interesting twist on a problem that has been solved in lots
of previous posts. I have a huge column of numerical data, with
'chunks' of cells of data separated by variably-sized 'chunks' of blank
cells. I would like to be able to apply a macro that will wade through
the data, splitting the big column into multiple columns, with each
'chunk' of data in its own individual column. Hopefully this will
clarify things for you:

Raw data:

1
2
3
4

4
5
7

12
3
5
67
7

Finished product:

1 4 12
2 5 3
3 7 5
4 67
7

Any help or code snippets from a curious expert would be greatly
appreciated!

 

[Guest]

see answer to your later posting of this question.