Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
<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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open txt file with more than 256 columns (how to tranpose in rows)? | Excel Discussion (Misc queries) |