Get Unique Record Pairings
I have a sheet that tracks the name of sub-contractors with the name of their business, and a column indicating the agency that sub-contractor works with. A single sub-contractor, Joe, from ABC Company, may work with Agency 123 and Agency 789, while Sally from ABC Company may work with Agency 567.
What I want to get to is a single row for ABC Company that shows me Agency 123, Agency 789 and Agency 567. I don't have the Pivot App, which seems like it would be the easiest way to do this. I did create a report grouped by sub-contractor business name, which sort of gets me what I need but there are multiple rows with the same data instead of a single row for each.
I'm not against creating some sort of grid with my sub-contractor business names as the Y axis, and the agency names as the X axis, with an X or something indicating if the sub-contractor business has any row with that agency's name in it, but before I go down that road I wanted to see if anybody had an ideas.
Help Article Resources
Check out the Formula Handbook template!