MERGING COLUMNS WITH DUPLICATE INFO.

If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter->Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.


"PatrickL" wrote:

> I really need help.
>
> I have two worksheets with data in columns A-G. Column B has content like
> "HDMU4524565". This is in column B of both worksheets. There are multiple
> duplicates in Column B on both worksheets. I need to combine the two
> worksheets keyed on column B and have no duplicates.
>
> I also need to pull the data in the other columns over that corespond with
> the entries in column B.
>
> Example:
>
> Column A Column B Column C Column D Column E Column F
> Column G
> Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> YES
>
> My boss is on me to do this report more efficiently.
>
> Any help is appreciated.

Thank You for your reply.

Not all of the data is duplicated. Some of the entries on sheet 1 do not
appear in sheet 2 and some data in sheet 2 does not appear in sheet 1. I need
to pull all of these into one list.

Does that make sense?


"Duke Carey" wrote:

> If the rows are complete duplicates - in other words, each cell in one of the
> duplicate records contains the exact same thing as the same cell in another
> duplicate, then it is easy.
>
> Create a 3rd worksheet and *copy* the data from your 2 current worksheets
> into the new one, one set of data immediately below the other set.
>
> Now, with any cell in the pasted data selected, use the Filter->Advanced
> Filter option on the Data menu and choose "Copy to another location" and
> check "Unique Records Only", then click in the Copy to: box and select a
> range on your worksheet that is empty and large enough to hold all the unique
> records. Click on OK and Excel will do the work for you.
>
>
> "PatrickL" wrote:
>
> > I really need help.
> >
> > I have two worksheets with data in columns A-G. Column B has content like
> > "HDMU4524565". This is in column B of both worksheets. There are multiple
> > duplicates in Column B on both worksheets. I need to combine the two
> > worksheets keyed on column B and have no duplicates.
> >
> > I also need to pull the data in the other columns over that corespond with
> > the entries in column B.
> >
> > Example:
> >
> > Column A Column B Column C Column D Column E Column F
> > Column G
> > Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> > YES
> >
> > My boss is on me to do this report more efficiently.
> >
> > Any help is appreciated.

If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter->Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.


"PatrickL" wrote:

> I really need help.
>
> I have two worksheets with data in columns A-G. Column B has content like
> "HDMU4524565". This is in column B of both worksheets. There are multiple
> duplicates in Column B on both worksheets. I need to combine the two
> worksheets keyed on column B and have no duplicates.
>
> I also need to pull the data in the other columns over that corespond with
> the entries in column B.
>
> Example:
>
> Column A Column B Column C Column D Column E Column F
> Column G
> Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> YES
>
> My boss is on me to do this report more efficiently.
>
> Any help is appreciated.

Thank You for your reply.

Not all of the data is duplicated. Some of the entries on sheet 1 do not
appear in sheet 2 and some data in sheet 2 does not appear in sheet 1. I need
to pull all of these into one list.

Does that make sense?


"Duke Carey" wrote:

> If the rows are complete duplicates - in other words, each cell in one of the
> duplicate records contains the exact same thing as the same cell in another
> duplicate, then it is easy.
>
> Create a 3rd worksheet and *copy* the data from your 2 current worksheets
> into the new one, one set of data immediately below the other set.
>
> Now, with any cell in the pasted data selected, use the Filter->Advanced
> Filter option on the Data menu and choose "Copy to another location" and
> check "Unique Records Only", then click in the Copy to: box and select a
> range on your worksheet that is empty and large enough to hold all the unique
> records. Click on OK and Excel will do the work for you.
>
>
> "PatrickL" wrote:
>
> > I really need help.
> >
> > I have two worksheets with data in columns A-G. Column B has content like
> > "HDMU4524565". This is in column B of both worksheets. There are multiple
> > duplicates in Column B on both worksheets. I need to combine the two
> > worksheets keyed on column B and have no duplicates.
> >
> > I also need to pull the data in the other columns over that corespond with
> > the entries in column B.
> >
> > Example:
> >
> > Column A Column B Column C Column D Column E Column F
> > Column G
> > Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> > YES
> >
> > My boss is on me to do this report more efficiently.
> >
> > Any help is appreciated.

If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter->Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.


"PatrickL" wrote:

> I really need help.
>
> I have two worksheets with data in columns A-G. Column B has content like
> "HDMU4524565". This is in column B of both worksheets. There are multiple
> duplicates in Column B on both worksheets. I need to combine the two
> worksheets keyed on column B and have no duplicates.
>
> I also need to pull the data in the other columns over that corespond with
> the entries in column B.
>
> Example:
>
> Column A Column B Column C Column D Column E Column F
> Column G
> Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> YES
>
> My boss is on me to do this report more efficiently.
>
> Any help is appreciated.

Thank You for your reply.

Not all of the data is duplicated. Some of the entries on sheet 1 do not
appear in sheet 2 and some data in sheet 2 does not appear in sheet 1. I need
to pull all of these into one list.

Does that make sense?


"Duke Carey" wrote:

> If the rows are complete duplicates - in other words, each cell in one of the
> duplicate records contains the exact same thing as the same cell in another
> duplicate, then it is easy.
>
> Create a 3rd worksheet and *copy* the data from your 2 current worksheets
> into the new one, one set of data immediately below the other set.
>
> Now, with any cell in the pasted data selected, use the Filter->Advanced
> Filter option on the Data menu and choose "Copy to another location" and
> check "Unique Records Only", then click in the Copy to: box and select a
> range on your worksheet that is empty and large enough to hold all the unique
> records. Click on OK and Excel will do the work for you.
>
>
> "PatrickL" wrote:
>
> > I really need help.
> >
> > I have two worksheets with data in columns A-G. Column B has content like
> > "HDMU4524565". This is in column B of both worksheets. There are multiple
> > duplicates in Column B on both worksheets. I need to combine the two
> > worksheets keyed on column B and have no duplicates.
> >
> > I also need to pull the data in the other columns over that corespond with
> > the entries in column B.
> >
> > Example:
> >
> > Column A Column B Column C Column D Column E Column F
> > Column G
> > Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> > YES
> >
> > My boss is on me to do this report more efficiently.
> >
> > Any help is appreciated.

If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter->Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.


"PatrickL" wrote:

> I really need help.
>
> I have two worksheets with data in columns A-G. Column B has content like
> "HDMU4524565". This is in column B of both worksheets. There are multiple
> duplicates in Column B on both worksheets. I need to combine the two
> worksheets keyed on column B and have no duplicates.
>
> I also need to pull the data in the other columns over that corespond with
> the entries in column B.
>
> Example:
>
> Column A Column B Column C Column D Column E Column F
> Column G
> Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> YES
>
> My boss is on me to do this report more efficiently.
>
> Any help is appreciated.

Thank You for your reply.

Not all of the data is duplicated. Some of the entries on sheet 1 do not
appear in sheet 2 and some data in sheet 2 does not appear in sheet 1. I need
to pull all of these into one list.

Does that make sense?


"Duke Carey" wrote:

> If the rows are complete duplicates - in other words, each cell in one of the
> duplicate records contains the exact same thing as the same cell in another
> duplicate, then it is easy.
>
> Create a 3rd worksheet and *copy* the data from your 2 current worksheets
> into the new one, one set of data immediately below the other set.
>
> Now, with any cell in the pasted data selected, use the Filter->Advanced
> Filter option on the Data menu and choose "Copy to another location" and
> check "Unique Records Only", then click in the Copy to: box and select a
> range on your worksheet that is empty and large enough to hold all the unique
> records. Click on OK and Excel will do the work for you.
>
>
> "PatrickL" wrote:
>
> > I really need help.
> >
> > I have two worksheets with data in columns A-G. Column B has content like
> > "HDMU4524565". This is in column B of both worksheets. There are multiple
> > duplicates in Column B on both worksheets. I need to combine the two
> > worksheets keyed on column B and have no duplicates.
> >
> > I also need to pull the data in the other columns over that corespond with
> > the entries in column B.
> >
> > Example:
> >
> > Column A Column B Column C Column D Column E Column F
> > Column G
> > Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> > YES
> >
> > My boss is on me to do this report more efficiently.
> >
> > Any help is appreciated.

If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter->Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.


"PatrickL" wrote:

> I really need help.
>
> I have two worksheets with data in columns A-G. Column B has content like
> "HDMU4524565". This is in column B of both worksheets. There are multiple
> duplicates in Column B on both worksheets. I need to combine the two
> worksheets keyed on column B and have no duplicates.
>
> I also need to pull the data in the other columns over that corespond with
> the entries in column B.
>
> Example:
>
> Column A Column B Column C Column D Column E Column F
> Column G
> Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> YES
>
> My boss is on me to do this report more efficiently.
>
> Any help is appreciated.

Thank You for your reply.

Not all of the data is duplicated. Some of the entries on sheet 1 do not
appear in sheet 2 and some data in sheet 2 does not appear in sheet 1. I need
to pull all of these into one list.

Does that make sense?


"Duke Carey" wrote:

> If the rows are complete duplicates - in other words, each cell in one of the
> duplicate records contains the exact same thing as the same cell in another
> duplicate, then it is easy.
>
> Create a 3rd worksheet and *copy* the data from your 2 current worksheets
> into the new one, one set of data immediately below the other set.
>
> Now, with any cell in the pasted data selected, use the Filter->Advanced
> Filter option on the Data menu and choose "Copy to another location" and
> check "Unique Records Only", then click in the Copy to: box and select a
> range on your worksheet that is empty and large enough to hold all the unique
> records. Click on OK and Excel will do the work for you.
>
>
> "PatrickL" wrote:
>
> > I really need help.
> >
> > I have two worksheets with data in columns A-G. Column B has content like
> > "HDMU4524565". This is in column B of both worksheets. There are multiple
> > duplicates in Column B on both worksheets. I need to combine the two
> > worksheets keyed on column B and have no duplicates.
> >
> > I also need to pull the data in the other columns over that corespond with
> > the entries in column B.
> >
> > Example:
> >
> > Column A Column B Column C Column D Column E Column F
> > Column G
> > Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> > YES
> >
> > My boss is on me to do this report more efficiently.
> >
> > Any help is appreciated.

I really need help.

I have two worksheets with data in columns A-G. Column B has content like
"HDMU4524565". This is in column B of both worksheets. There are multiple
duplicates in Column B on both worksheets. I need to combine the two
worksheets keyed on column B and have no duplicates.

I also need to pull the data in the other columns over that corespond with
the entries in column B.

Example:

Column A Column B Column C Column D Column E Column F
Column G
Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
YES

My boss is on me to do this report more efficiently.

Any help is appreciated.

If the rows are complete duplicates - in other words, each cell in one of the
duplicate records contains the exact same thing as the same cell in another
duplicate, then it is easy.

Create a 3rd worksheet and *copy* the data from your 2 current worksheets
into the new one, one set of data immediately below the other set.

Now, with any cell in the pasted data selected, use the Filter->Advanced
Filter option on the Data menu and choose "Copy to another location" and
check "Unique Records Only", then click in the Copy to: box and select a
range on your worksheet that is empty and large enough to hold all the unique
records. Click on OK and Excel will do the work for you.


"PatrickL" wrote:

> I really need help.
>
> I have two worksheets with data in columns A-G. Column B has content like
> "HDMU4524565". This is in column B of both worksheets. There are multiple
> duplicates in Column B on both worksheets. I need to combine the two
> worksheets keyed on column B and have no duplicates.
>
> I also need to pull the data in the other columns over that corespond with
> the entries in column B.
>
> Example:
>
> Column A Column B Column C Column D Column E Column F
> Column G
> Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> YES
>
> My boss is on me to do this report more efficiently.
>
> Any help is appreciated.

Thank You for your reply.

Not all of the data is duplicated. Some of the entries on sheet 1 do not
appear in sheet 2 and some data in sheet 2 does not appear in sheet 1. I need
to pull all of these into one list.

Does that make sense?


"Duke Carey" wrote:

> If the rows are complete duplicates - in other words, each cell in one of the
> duplicate records contains the exact same thing as the same cell in another
> duplicate, then it is easy.
>
> Create a 3rd worksheet and *copy* the data from your 2 current worksheets
> into the new one, one set of data immediately below the other set.
>
> Now, with any cell in the pasted data selected, use the Filter->Advanced
> Filter option on the Data menu and choose "Copy to another location" and
> check "Unique Records Only", then click in the Copy to: box and select a
> range on your worksheet that is empty and large enough to hold all the unique
> records. Click on OK and Excel will do the work for you.
>
>
> "PatrickL" wrote:
>
> > I really need help.
> >
> > I have two worksheets with data in columns A-G. Column B has content like
> > "HDMU4524565". This is in column B of both worksheets. There are multiple
> > duplicates in Column B on both worksheets. I need to combine the two
> > worksheets keyed on column B and have no duplicates.
> >
> > I also need to pull the data in the other columns over that corespond with
> > the entries in column B.
> >
> > Example:
> >
> > Column A Column B Column C Column D Column E Column F
> > Column G
> > Hunter HDMU454657 SMITH 7/5/05 8/5/05 8/5/05
> > YES
> >
> > My boss is on me to do this report more efficiently.
> >
> > Any help is appreciated.