Matching Multiple Values And Moving Cell Info

[homchz]

I have a list of about 18000 records comparing accounts from two databases. At one point people thought it would be a good idea to have different account numbers...
My list looks like this:
Accounts1.PNG
I can match the First account number And at least the first 7 characters of the address.

I would like it to look like this in the end not sure if it can be done in one sheet or if it has to be populated into it's own sheet:
accounts2.PNG

Any thoughts or direction someone can point me in??

Thanks,

[PCI]

To be clear, you want the same result as for 182P50 to be done for 1848P and 1BEAP01 etc ...
Can you send a short Excel sample

[kvsrinivasamurthy]

Pl upload a sample file.

[sintek]

Please excuse my ignorance...but why would your outcome not be the same as for 182P50...There doesn't seem to be consistency.

Untitled-1.gif


For above outcome:

Please Login or Register  to view this content.

[jindon]

If no header and data starts from A1.
Simply

Please Login or Register  to view this content.

Otherwise, need to see your workbook.

[homchz]

The data is merged like accounts from two different data bases that were set up differently. So in one system the account number is 182P50 with a site location of 182P500000. And the other is 182P50 with a site location of BOST. But I need to find a way to easily relate the two together in one sheet for a data import into a new system.

So this is to match the 182P500000 to BOST. And so on through out the entire spread sheet.

Attached is a small sample of accounts. Some have matches, some do not. Some are not right above the others one for one.

Thanks,

[PCI]

Thanks for the file
What about
16AP50 SPRI
16AP50 EAST
16AP50 LONG
16AP50 16AP500000
16AP50 16AP500001
16AP50 16AP500002

What is the final result ??

[homchz]

If there is no matching address. The I would like to to remain blank as that will tell me what addresses are not populated in the main database and I will have to create by hand.

if the Street address matches Ultimately I am looking for

16AP50 16AP500000 (No Matching address in Address_1 or Address_2 so leave Blank)
16AP50 16AP500000 (No Matching address in Address_1 or Address_2 so leave Blank)
16AP50 16AP500002 SPRI

Hope that makes sense.

[PCI]

If my understanding is right you want to merge data into one row when:
"CustomerNumber" and "Site Name" and "Address_1" and "Address_2" are the same
then "Site_Id" and "ShipToCode" will exist only once and must be recorded in the final row
Is it ?
If not, please show in your final the final result you need

[homchz]

If my understanding is right you want to merge data into one row when:
"CustomerNumber" and "Site Name" and "Address_1" and "Address_2" are the same
then "Site_Id" and "ShipToCode" will exist only once and must be recorded in the final row
Is it ?
If not, please show in your final the final result you need

That is it.

[PCI]

Perhaps try
Note: There is some spaces in column "CustomerNumber" they are removed in the macro

Please Login or Register  to view this content.