Hello,
I am needing some help combining rows which have a duplicate unique ID in VBA.
Please see the following example
Unique ID (Column A) Constructive Placement Date (Column B) Actual Placement date (Column C) NDYX89207011/25/2017 18:38:00 11/25/2017 NAHX32023512/14/2017 13:01:00 11/25/2017 CAIX09567612/30/2017 21:55:00 11/25/2017 NDYX89207011/25/2017 18:38:00 11/25/2017 12/25/2017 CAIX09567612/30/2017 21:55:00 11/25/2017 12/25/2017
So basically what I need to do is combine the rows with the duplicate unique ID's so that the row reflects the the actual placement date. Also if there is no actual placement date, the actual placement date column stays blank
I have tried doing nested loops, and using formulas on the work sheet to merge these rows together, but nothing's working
Also there is a lot more records than just the few in the table
Any help would be great!
Thanks
Bookmarks