count info separated by comma

[jps_HHH]

I ve a database with some info separated by commas and I d like to count the number of I2 , H2, AB, etc

(the result should be: I2 -> 1 ; AB ->11; HQ -> 15 etc)

book

I2, H2

AB

H2

LR

AB

H2, AB

H2

AB

GH, H2

H2

H2

AB

LR

GH, H2

AB

GH, H2, AB

H2, AB

H2, AB

GH

H2, AB

GH, H2

GH, AB

H2, AB

H2

H2

[PhilipTreacy · Accepted solution]

Hi, @jps_HHH 

Download example PBIX file

In Power Query, Split the Column by Delimiter and choose to create new rows.

Then clean/trim the column to remove whitespace and load to PBI.

Create a table and add Count as the 2nd column

Regards

Phil