Hi ahoneycutt and welcome to the forum.
I have assumed that in the example output row 7 the duplicates of 384484 Cheryl Ray are typos.
In the attached the output is below yours.
In the Location column I copied / pasted the source and applied 'Remove duplicates'. It seemed simpler.
Array-enter this formula in G12. Then fill down and across to L17. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
Bookmarks