Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate 2 Columns into 1
I would like to vertically cosolidate data from Column A and Column B into
Column C, excluding duplicate data. Suggestions? Thanks! Example: A B C 1 AAA AAA AAA 2 BBB EEE BBB 3 CCC FFF CCC 4 EEE 5 FFF 6 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate 2 Columns into 1
1. Copy col A n paste below col B
2. Run DataFilterAdvanced FilterUnique records only on combined col B to output into col C 3. Data Sort col C as desired -- Max Singapore http://savefile.com/projects/236895 Downloads:16,400 Files:356 Subscribers:53 xdemechanik --- "hookooekoo" wrote: I would like to vertically cosolidate data from Column A and Column B into Column C, excluding duplicate data. Suggestions? Thanks! Example: A B C 1 AAA AAA AAA 2 BBB EEE BBB 3 CCC FFF CCC 4 EEE 5 FFF 6 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate 2 Columns into 1
I was hoping for something more automatic I could set up to combine the
columns and was also hoping for something that I could expand on to combine more than 2 columns. But thanks for the input anyway. "Max" wrote: 1. Copy col A n paste below col B 2. Run DataFilterAdvanced FilterUnique records only on combined col B to output into col C 3. Data Sort col C as desired -- Max Singapore http://savefile.com/projects/236895 Downloads:16,400 Files:356 Subscribers:53 xdemechanik --- "hookooekoo" wrote: I would like to vertically cosolidate data from Column A and Column B into Column C, excluding duplicate data. Suggestions? Thanks! Example: A B C 1 AAA AAA AAA 2 BBB EEE BBB 3 CCC FFF CCC 4 EEE 5 FFF 6 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Consolidate 2 Columns into 1
Not easy to do step 1 & 3 via formulas. Suggest you record a macro when you
do the 3 steps, then try a post in .programming for help to generalize the macro to suit. -- Max Singapore http://savefile.com/projects/236895 Downloads:16,400 Files:356 Subscribers:53 xdemechanik --- "hookooekoo" wrote in message ... I was hoping for something more automatic I could set up to combine the columns and was also hoping for something that I could expand on to combine more than 2 columns. But thanks for the input anyway. "Max" wrote: 1. Copy col A n paste below col B 2. Run DataFilterAdvanced FilterUnique records only on combined col B to output into col C 3. Data Sort col C as desired |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i consolidate 13 spreadsheets onto one | Excel Worksheet Functions | |||
consolidate data | Excel Worksheet Functions | |||
consolidate | Excel Discussion (Misc queries) | |||
Consolidate | Excel Discussion (Misc queries) | |||
Consolidate sheets | Excel Worksheet Functions |