Heya, I'm working on a rather large spreadsheet for my company and I'm completely stuck on where to continue!
So, I have a list of about 35,000 people, each person is unique, but the Fax# has duplicates.
I need to create a spreadsheet which lists each fax number in column A, and then has one long string of all the names that have that as their fax number in column B, so, what I have looks like:
Current.jpg
And I need to turn it into:
End.jpg
Any ideas? Any help is greatly appreciated! Thanks!
Hello and welcome to the forum,
Could you upload a sample workbook rather than pictures? Also you can search for Concat on the forum and will find many similar solutions.
Hope this helps.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
This link may give you a good place to start.
http://office.microsoft.com/en-us/ex...001226038.aspx
Hey, thanks for the link, I looked on microsoft's site but didn't have much luck, but that link might work for what I need...
I'll also take a better look around the forums, I didn't look too in depth before, and I'll upload a sample workbook in just a few minutes here...
Thanks!
Last edited by Garetsu; 09-29-2011 at 03:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks