help urgent


hey guys

hows it going? I need your help once again....i have an excel file with
loads of data

ie.

A ....G H I J
K L
1 10465 Jason Brad Mike Jeff
Heather Lebron

2 1076 Keith Jay Fred David
Young Pat

and it goes all the way down to A4056.....however on a seperate *** I
need this information copied like this

*** 2

A B
1 10465 Jason
Brad
Mike
Jeff
Heather
Lebron

2 1076 Keith
Jay
Fred
David
Young
Pat

once again, it goes all the way down to A4056. is there a way either
thru macro or thru formula for me to do this instead of copying and
pasting special? help will be much appreciated; please and thank you.
hope you follow what I was trying to get at.....


--
daroc
------------------------------------------------------------------------
daroc's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30753
View this thread: http://www.excelforum.com/showthread.php?threadid=506753

.