Hello all:
I have a workbook that tracks mods by their number. Each row represents a unique Mod number. Multiple Agencys can be associated with one Mod number and I list them, separated by a comma in the applicable cell in the Agency column.
I am trying to get a pivot table to recognize that there are multiple entries in the Agency cell and associate the single mod number with each agency.
I have attached a sample work book with what I think the correct outcome should be.Sample Workbook (Excel_Forum).xlsx
Bookmarks