Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a list of names, represented below, but in reality about 1,000 names
long. Column A has each name ONCE. Column B has each name multiple times, but in no particular order. I want to have the names in Column B be at the same place as column A. In other words, for the name "John" in Column A, I want each instance of "John" in Column B to come under that . What this will require is Excel to AUTOMATICALLY insert additional cells (so that if John appears 20 times in Column B, there are 19 blank lines under "John" in Column A). PLEASE HELP!!! Jeff John John John Saul John Ralph Jeff Jeff Jeff John John Saul Saul Jeff Ralph Jeff Ralph Ralph Ralph Ralph John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Complicated Excel Mailing List | Excel Worksheet Functions | |||
sorting in excel 2003 | Excel Worksheet Functions | |||
Sorting alphabetical list into multiple columns | Excel Worksheet Functions | |||
Sorting in Excel 2003 | New Users to Excel | |||
Sorting multiple columns as 1 list alphabetically? | Excel Discussion (Misc queries) |