| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rows to Columns on reference
I have a large file laid out as follows below.
Column A Column B SSN1 Name1 SSN1 Address1 SSN1 Address 2 SSN1 City, State Zip SSN2 Name2 SSN2 Address1 SSN2 City, State Zip SSN2 SSN3 Name3 SSN3 Address1 SSN3 City, State Zip SSN4 Name4 SSN4 Address1 SSN4 Address 2 SSN4 City, State Zip How can I get this data to look like: Column A Column B Column C Column D Column E Column F SSN # Full Name Address Line 1 Address Line 2 Address Line 3 City, State Zip SSN1 Name1 Address1 Address 2 City, State Zip SSN2 Name2 Address1 City, State Zip SSN3 Name3 Address1 City, State Zip SSN4 Name4 Address1 Address 2 City, State Zip |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do change rows to colums AND columns to rows | Excel Discussion (Misc queries) | |||
| Rows & Columns in Excel | Excel Worksheet Functions | |||
| How can I transpose rows to columns in a large worksheet? | 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) | |||
Threaded Mode
