| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Moving data: vertical to horizontally laid cells
Does anyone know an automated way to get data that is listed in cells going
down the page (vertically) into cells that go across the page (horizontally)? For example: Name Randy Address 10 Apple Road City Anytown State CA Zip 90001 Would become: Name Address City State Zip Randy 10 Apple Road Anytown CA 90001 I've been wondering this for years!! Thanks, Edward |
|
#2
|
|||
|
|||
|
Moving data: vertical to horizontally laid cells
Copy-- then Edit--Paste special--Transpose
You may need to paste it to a new worksheet. ************ Anne Troy www.OfficeArticles.com "Edward Chambers" wrote in message ... Does anyone know an automated way to get data that is listed in cells going down the page (vertically) into cells that go across the page (horizontally)? For example: Name Randy Address 10 Apple Road City Anytown State CA Zip 90001 Would become: Name Address City State Zip Randy 10 Apple Road Anytown CA 90001 I've been wondering this for years!! Thanks, Edward |
|
#3
|
|||
|
|||
|
Moving data: vertical to horizontally laid cells
Have you tried to copy the data, move to an empty area of the worksheet, and
using Edit-Paste Special-Transpose? Should do what you want. "Edward Chambers" wrote: Does anyone know an automated way to get data that is listed in cells going down the page (vertically) into cells that go across the page (horizontally)? For example: Name Randy Address 10 Apple Road City Anytown State CA Zip 90001 Would become: Name Address City State Zip Randy 10 Apple Road Anytown CA 90001 I've been wondering this for years!! Thanks, Edward |
|
#4
|
|||
|
|||
|
Moving data: vertical to horizontally laid cells
Thanks to both of you, Anne and Duke.
Works like a charm -- even copies formulas correctly. I'm loving Excel today! =) Thanks. "Anne Troy" wrote: Copy-- then Edit--Paste special--Transpose You may need to paste it to a new worksheet. ************ Anne Troy www.OfficeArticles.com "Edward Chambers" wrote in message ... Does anyone know an automated way to get data that is listed in cells going down the page (vertically) into cells that go across the page (horizontally)? For example: Name Randy Address 10 Apple Road City Anytown State CA Zip 90001 Would become: Name Address City State Zip Randy 10 Apple Road Anytown CA 90001 I've been wondering this for years!! Thanks, Edward |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to copy cells horizontally to cells out of sequence | Excel Discussion (Misc queries) | |||
| Reference multiple cells in if statement | Excel Worksheet Functions | |||
| How do I rotate Horazontial cells vertical, so part of the chart . | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
Linear Mode
