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

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

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

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