Hello,
I have a file with two columns, ID and Date. In most cases, there is one date per ID, but in many cases there are multiple dates with a common ID. I'm looking for help with creating a macro that brings the dates into more columns to the right of the common ID, at the same time deduping the IDs. I've attached an example of what I'm looking for: the tab "start data" is what I have currently, and the tab "result" is what I'm looking for.
Any help would be much appreciated!
Thanks
Bookmarks