Tranpose?

T

TARZAN

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?
 
G

Guest

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'
 
A

Amedee Van Gasse

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'
Click to expand...

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

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.deBoynePollard/FGA/questions-with-yes-or-n
o-answers.html
 
Top