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-