Hi
First, take a copy before you start!
Select the whole area, click on Edit /Copy (or Ctrl+C) and then click on
Edit / Paste Special and select 'Transpose'

--
Andy.


"TARZAN" wrote in message
...
I have a list 801 records like this

ABC TLD
420 Plaisade Ave
Yonkers, NY
(914)5561234

John Spencer
Lake Ave
White Plains, NY
(914)5461234

And I want to put data like this

ABC TLD 420 Plaisade Ave Yonkers, NY
(914)5561234
John Spencer Lake Ave White Plains, NY
(914)5461234


Is it possible?
--
Thanks