Row extractor

[datamanipulator]

I need to reformat data 12 columns and x-rows to two contiuous columns-

 

[OssieMac]

Can you post an example of the existing data and an example of what you want
it to look like after reformatting.

 

[datamanipulator]

Something along the lines:

1,2,3,4,5,6,7,8,9,10,11,12
13,14,15,16,17,19,19,20,21,22,23,24
.........

to
1
2
3
4
...
...
...
23
24

 

[Gord Dibben]

Your desired output example shows only one column.

Your original post stated two columns.

Which do you want?


Gord Dibben MS Excel MVP

 

[datamanipulator]

The base table is hourly data across several years presented as a table of
13 rows- row A is Date and then two rows per day- am and then pm data- then
into the next date on the third row.....
My need is for two cols of data: Date\time and then the cols for each day
transposed into one continuous column. For several years of data I need
something more than just the copy\transpose feature.
The first col is to be date\time- which can be created- so hence my
simplified question>

Many thanks.