Row extractor
 

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

Row extractor
 

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-

Row extractor
 

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-

Row extractor
 

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-

Row extractor
 

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-