| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
turn rows into columns
Thanks!
This information was very helpful to me!! Grace mpenkala wrote: Hi there, Have you tried using the 'Transpose' Function in Excel? It allows you to move data between rows and columns. - Copy the data in one or more columns. - Before you paste the copied data, right-click your first destination cell (the first cell of the row or column into which you want to paste your data), and then click Paste Special. - In the Paste Special dialog box, select Transpose, and then click OK. (You'll find theTranspose check box in the lower-right corner of the dialog box) Hope this helps, Matt P. "savbci" wrote: I have an excel file with hundreds of rows as follows: A1= Name, A2 = George Smith B1= Firm, B2 = Sears C1=Phone number, C2 = 519-555-4545 E1= Name, E2= Jane Brown F1= Firm, F2 = IBM G1=Phone number, G2 = 905-555-4545 I would like the end result to in 'column' format (so every record on each row) Column Headings: Name/Firm/Phone numbers George Smith/Sears/519-555-4545 Jane Brown/IBM/905-555-4545 How can i achieve this...i have about 500 records. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| convert columns to rows & rows to columns | Excel Discussion (Misc queries) | |||
| How to swap rows and columns? | Excel Discussion (Misc queries) | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| How to keep rows together when sorting columns? | Excel Worksheet Functions | |||
| Printing problems with columns and rows | Excel Discussion (Misc queries) | |||
Hybrid Mode
