Let’s say I have these columns:
Address | Primary Agent | Secondary Agent
The address is a unique entry, one per row. Each Agent shows up for several Addresses on the sheet. There are several other detail columns, but it is not important for this question. Now I want a tab that lists all Addresses in a list or cards, but I want it grouped by each Agent. So the address will essentially have to show up twice on the tab (unless no Secondary Agent is listed). The Address (and details) will be listed once under each Agent.
Is this possible?