Duplicates with different data to combine with VBA

[chipsworld]

Hello all,
Once again, I find myself seeking help... (Glad this forum is here!!!)

I have a spreadsheet with 21 columns with various data.

Column 1 is a part number, column 3 is a product type and column 6 is a date range

The problem is this...there can be anywhere from 2 to 7 lines with the same part number and each row with that part number can have different date ranges.

I am looking for a way to use the part number as the common string and combine the data in column 6 into a single entry:

ie. If I had three lines with the same part number, but the date ranges in each row were different, how can I concatenate them into one cell.

The spreadsheet has around 5000 rows of data with a LARGE amount of repeated part numbers, and I receive a new sheet each week that needs to be "blended" into the master.

I don't want anyone to do it for me, I would just like pointers on how to proceed. I honestly can't even figure out where to start.

I am guessing that it will incorporate some type of concatenate or textjoin or ??

Thanks for any tips on how to approach this.

 

[mse330]

Hi chipsworld,

Using Dictionary object would be helpful in your situation which will allow you to get the unique part numbers then just add the date ranges to each part number then paste the results in a new tab. If you need further assistance with the code, I would be happy to help.

 

[chipsworld]

mse330...I am new to the Dictionary object, so am gonna try to figure this thing out, but...be prepared for questions! LOL

Thanks for the guidance. Let's see if I can figure it out.