Hello,

I am working on summarizing data that was given to me in a format like:

Ref Num Group Score Category (below are in one cell)
205 AA 3 Asset, Liability
206 BB 2 Revenue, AR, Asset
207 AA 1 Liability
208 CC 3 Expense, Liability
208 AA 2 Asset, Expense
205 CC 2 Asset

I want to end up summarizing the information into a report/pivot table,
chart, something that would look something like:

Group Category Ref Score
AA Asset 205 3
AA Liability 205 3
AA Asset 208 2
BB Revenue 206 2
BB AR 206 2
BB Asset 206 2
€¦
This would break out the category column to allow for each category type to
have its own line. I am not sure if this possible but I am looking for ideas.

Thanks,
CB