Common items and their Count with a Specific Criteria

anupambit1797 

Clean up with PQ and then pivot.

In PowerQuery you'll do:

Stepping through this:

-table your source and load into PQ

-remove the second step which converts the SNs to numbers (and removes the comma)

-remove every column except sub cell and SN

-split the SN column by comma - specify 4 columns

-select the subcell column and go to Transform | Unpivot other columns

-remove the attribute column

-filter SN to remove empties

-load to sheet and pivot

-enjoy!