I have names in a list and differing numbers of values in the second column.
eg:
sam has 3 entries
bob has 5 entries
Jill has 2 entries.
I want one line per name and the entries transposed on each line. See attached please.
I have names in a list and differing numbers of values in the second column.
eg:
sam has 3 entries
bob has 5 entries
Jill has 2 entries.
I want one line per name and the entries transposed on each line. See attached please.
Give this macro a try. Results will be added to sheet2
Please Login or Register to view this content.
Last edited by mike7952; 11-25-2012 at 07:12 PM.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
If you can create a list of unique names, you can use the method in the attached file...
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you Mike, worked a treat.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks