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