Forum Discussion
Excel Help
I was sent a contact information list & the same name is listed multiple times with different emails. (Each person has more than 1 email address.) If we upload into our system as is, it creates a sep...
You don't mention your version of Excel. The attached sheet shows a method that will work with a Microsoft 365 subscription or Excel 2021 or newer.
Two formulas are needed.
=SORT(UNIQUE([list of names])), e.g., =SORT(UNIQUE(A1:A2000))
=TRANSPOSE(FILTER(Table1[Emails],Table1[Names]=E2))
the first formula, the one with "unique" in it, only is entered once; the results all spill to rows below.
the second formula needs to be copied to cells adjacent to the list of unique names
And of course, if John Smith is listed as John Smith each time, that's not a problem, but if he's sometimes John Q. Smith, then that is a different name as far as Excel is concerned. So you may need to do some cleaning up when that occurs.