Hi All,
Issue
My data set has 35000 records belonging to 1800 unique Party ID's (col A)
I need to convert this data set into a single row for each unique party id. Col S is the issue - I need to transpose the values in Col S which pertain to the party id.
I have include a before and after which clearly demonstrates my desired output.
Many thanks for looking
Last edited by Blake 7; 11-12-2013 at 12:25 PM.
Blake 7
If your question has been answered, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.
If any member's response has helped to solve your problem, please consider using the scales icon on the top right of their post to show your appreciation.
http://failblog.org/
Try this code
Please Login or Register to view this content.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi Arlu - i'll give it a shot now and get back to you. Cheers man
as an option
Please Login or Register to view this content.
Hi Guys - thanks so much - awesome!
Kind of you to take the time to help me.
Nilem - i really appreciate the uploaded sample. Spacibo!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks