how to append data to rows based on a condition

Hi,

I am working on a huge dataset containing data of thousands of IDs in which I have to append data from within the rows as shown in attached image. aaa.png

I want such a VBA program or any method that will look for the most recent date for an ID such as in the given example, we have ID '111'. Now for '111' there are three dates. The program should move to the row with most recent date which is 04-Dec and then append the data from the previous dates for the same ID at the end of this. There can be instances more or less than 3 for an ID.

Move your table to start in A1. This code assumes that the table is completely filled - no blanks in any cell. Note the optional line at the bottom - un-comment it if you want to remove the extra rows.

Please Login or Register  to view this content.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.