bj,
I try that and I could not get more than 13 rows in there. There is a
character limit for "y" :(

Jon,
The data is from another department and they want to keep in seperate
row/column for another purpose.

I might have to manually copy and paste into one column. :( there are a
lot of sheets I have to do it on, cause they have a lot of data
history.

Is there a command or macro where I could run and just copy and past
many columns into one column?


--
Zawa
------------------------------------------------------------------------
Zawa's Profile: http://www.excelforum.com/member.php...o&userid=32263
View this thread: http://www.excelforum.com/showthread...hreadid=520172