D
datamanipulator
I need to reformat data 12 columns and x-rows to two contiuous columns-
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
O
OssieMac
Can you post an example of the existing data and an example of what you want
it to look like after reformatting.
it to look like after reformatting.
D
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
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
G
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
Your original post stated two columns.
Which do you want?
Gord Dibben MS Excel MVP
D
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.
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.