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
Hi theletterh
try this attached file and let me know
just open the file and press Alt+F8 and run the macro
Thanks - Naveed
-----------------------------
If the suggestion helps you, then Click * to Add Reputation
To Attach File: Go Advanced>>Manage Attachments>>Add Files (In Top Right Corner)>>SelectFiles>>.........Locate Your File(s)>>Upload Files>>Done (In Bottom Right)
1. Use [code] code tags [\code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
Hi Naveed,
It worked fine for the example, but my actual file has over 375K records. It churned for a while but never completed. Is there a simpler way?
Try the attached.
Thank you AB33!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks