Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
One column to multiple columns
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
One column to multiple columns
See your later post.
Tenacious Lee wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
One column to multiple columns
see answer to your later posting of this question.
-- Regards, Tom Ogilvy "Tenacious Lee" wrote: 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
from one column into multiple columns | Excel Discussion (Misc queries) | |||
Convert multiple columns into on column? | Excel Discussion (Misc queries) | |||
XML Column to Multiple Columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) |