Difficult Concatenate Issue

**Garetsu** · 09-29-2011, 03:14 PM

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!

**abousetta** · 09-29-2011, 03:17 PM

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

**Whizbang** · 09-29-2011, 03:17 PM

This link may give you a good place to start.

http://office.microsoft.com/en-us/ex...001226038.aspx

**Garetsu** · 09-29-2011, 03:26 PM

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!