Merge Duplicate Rows

**mattvcommuter** · 02-01-2011, 03:13 AM

I have a spreadsheet which contains inventory data from two pre-existing sheets. I need to find the rows where part numbers (column A) are duplicate. Then I need the rows with duplicate part numbers to be merged and retain the data in all columns from both rows. Essentially, I have many rows where cells in duplicate "row 1" are blank, but contain data in duplicate "row 2". In the cases where data exists in particular cells in both rows, it doesn't matter which row's existing data is kept. Naturally, I only want to keep one row from the duplicates. Here's an example of what it looks like:

Before::
Row / Part Number / Description / Inventory Type / Vendor / Quantity
1 / 100111 / Large Sprocket / Machine Part / / 250
2 / 100111 / Large Sprocket / / ACME Sprockets /

After::
Row / Part Number / Description / Inventory Type / Vendor / Quantity
1 / 100111 / Large Sprocket / Machine Part / ACME Sprockets / 250

Hope this makes sense.. seems like it should be ridiculously simple. ?? The actual spreadsheet file is attached below.

Thanks in advance!

**Blake 7** · 02-01-2011, 04:23 AM

Hi - can you please attach the spreasheet?

**mattvcommuter** · 02-01-2011, 09:16 AM

yes... here's the spreadsheet. Thanks!

**mattvcommuter** · 02-01-2011, 02:07 PM

my apologies.. this is the correct spreadsheet. Appreciate the help!

**Blake 7** · 02-02-2011, 04:50 AM

Ive had a look at your data - in particular, col A, part number, i have found that some part numbers are not numbers and in some cases are the same values as the description. Can this be right?

Here are some examples.

250cc duke blackout oil gauge
250cc duke blackout oil gauge
250cc duke blackout pod cup
250cc duke blackout pod cup
250cc duke chrome vanity covers
250cc duke chrome vanity covers
250cc duke water pump bearing
250cc duke water pump bearing
250cc duke water pump gasket
250cc duke water pump gasket
250cc duke water pump seal
250cc duke water pump seal
250cc duke water pump seal gaske
DEPOSIT
DEPOSIT
Diagnostic
Dipstick
Dipstick
Discount
Discount
Hydraulic Brake Shoe - Front
Hydraulic Brake Shoe - Front
Industrial Cleaning Solvent Can
Industrial Cleaning Solvent Can
OILDYE
OILDYE
OIL-IPCITY
OIL-IPCITY
OIL-IPRUN
OIL-IPRUN
oilline
oilline
OIL-MOT710
OIL-MOT710
OIL-SYN
OIL-SYN
Out of State
STOBEL TROMBE AIR HORNS
STOBEL TROMBE AIR HORNS
STORAGE
STORAGE
Storage Rent
TANK CLASSIC 150
tank-viaggio rear tire compleat
tank-viaggio rear tire compleat