Tranpose?
 

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

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

<Andy B shared this with us in microsoft.public.excel.misc:

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'

That won't work as desired!
You will have to write some VBA to achieve your goal, I guess. I have
no time now to elaborate, sorry.

--
Amedee Van Gasse using XanaNews 1.17.3.1
If it has an "X" in the name, it must be Linux?

How To Ask Questions The Smart Way
http://www.catb.org/~esr/faqs/smart-questions.html
How to Report Bugs Effectively
http://www.chiark.greenend.org.uk/~sgtatham/bugs.html
Only ask questions with yes/no answers if you want "yes" or "no" as the
answer.
http://homepages.tesco.net/~J.deBoyn...-with-yes-or-n
o-answers.html