Remove duplicates after updating rows

[k_krishna]

Hi All,

I have a spread sheet which has a range as shown below.

Batch Number Item 1 Item 2 Item 3
P1 556 35
P2 54
P3 78
P2 568
P4 54
P3 89
P3 85

I need to get the output as shown below which is for Batch number P2 I need to include Item 1 (568) in one row and delete the other P2 row. similarly I need to do for P3. The end result will be as shown below. Please advice on how to make a macro for this. (I have also attached a spreadsheet ) Any help is appreciated.

Batch Number Item 1 Item 2 Item 3
P1 556 35
P2 568 54
P3 89 85 78
P4 54

[:) Sixthsense :)]

Use Pivot Table

[k_krishna]

Hello Sixthsense

That was very quick and that is just perfect. It worked. Now I need to try that in my office where the data is insanely huge.. I shall update you on how you went.

Once again, thanks a bunch. Never thought a simple Pivot table could do the magic..

[:) Sixthsense :)]

You're welcome and thanks for the feedback

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

[nilem]

as an option

Please Login or Register  to view this content.

[sktneer]

Try this code on your attached sheet to see if this works as per your requirement. But before trying this code on that sheet, delete all the rows below row 13 where you mentioned the steps and desired output manually.

Please Login or Register  to view this content.

Hope that helps.

[Winon]

Personally I would go with the Code as posted by nilem.

[k_krishna]

Very responsive Forum. A BIG THANKS YOU ALL

[sktneer]

You're welcome. Glad it helped. Thanks for the feedback and the Rep.