Is it possible to associate a range of cells containing different information based on like values in other cells?
Example:
How it currently appears in spreadsheet
Name Acct#
John Q. Public 11111
John Q. Public 22222
John Q. Public 33333
John Q. Public 44444
Jane Example 88888
Jane Example 99999
Wanted Result
John Q. Public 11111 22222 33333 44444
John Q. Public 11111 22222 33333 44444
John Q. Public 11111 22222 33333 44444
John Q. Public 11111 22222 33333 44444
Jane Example 88888 99999
Jane Example 88888 99999
I know how to remove the duplicates afterwords to get one unique record per person.
Bookmarks