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

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

OssieMac


"datamanipulator" wrote:

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

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

"OssieMac" wrote:

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

Regards,

OssieMac


"datamanipulator" wrote:

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

Your desired output example shows only one column.

Your original post stated two columns.

Which do you want?


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 14:58:03 -0800, datamanipulator
wrote:

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

"OssieMac" wrote:

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

Regards,

OssieMac


"datamanipulator" wrote:

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

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.


"Gord Dibben" wrote:

Your desired output example shows only one column.

Your original post stated two columns.

Which do you want?


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 14:58:03 -0800, datamanipulator
wrote:

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

"OssieMac" wrote:

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

Regards,

OssieMac


"datamanipulator" wrote:

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