| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Transposing *lots* of rows
I have about 50K entries in one row that need to go from vertical to
horizontal. Each is a name, address, etc., so when I get done it should be about 10K entries. Right now it looks like this: Name Address City, ST Zip Phone And what I'm wanting is Name | Address | City | ST | Zip | Phone I know I can do each row separately (copy / paste special / transpose), is there a faster way to execute it in bulk? Thx! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transposing columns to rows | Excel Discussion (Misc queries) | |||
| Pasting /transposing from rows to columns. | Excel Discussion (Misc queries) | |||
| Transposing a column to several rows | Excel Discussion (Misc queries) | |||
| Transposing a column to several rows | Excel Worksheet Functions | |||
| hOW TO DELETE THE - IN (23-HFV51), I HAVE LOTS OF ROWS WITH DATA. | Excel Discussion (Misc queries) | |||
Threaded Mode
