| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
SORT REPETITIVE DATA FROM ROWS TO COLUMNS
I have a column of repetitive data:
BLANK CELL NAME ADDRESS CITY, STATE ZIP BLANK CELL I would like to be able to resort the dats so that each line becomes a column BLANK CELL NAME ADDRESS CITY, STATE ZIP BLANK CELL I know I can do it 3 cells/rows at a time using the paste special and transpose command but I have a 1000 names and addresses. How do I do it in one operation instead of a thousand? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query doesn't add/delete data in rows on refresh | Excel Discussion (Misc queries) | |||
| Can I rotate data in Excel table (rows to columns, and vv)? | Excel Discussion (Misc queries) | |||
| text data in one column many rows to many columns one row | Excel Discussion (Misc queries) | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
