How to count each instance of a value in a single column but for all records

[jose_cruzrodz]

Hello.

My source data has two columns. The first one is a Unique ID (no duplicates) and the second is a list of individual Codes, separated by comma, within each cell. Each individual Code can show up in my dataset mutiple times. Look at the following screenshot:

For example, Codes 0101 and 0104 show up in records 1, 4, 6 and others. We see records with only one Code but others have multiple codes. All that is fine.

What I want to accomplish is knowing how many times Code 0101, for example, has come up in my dataset. The answer to my question is 16 times. I want to be able to complete this count for every Code. Another example, Code 0224 is listed 6 times, while Code 0203 is listed 8 times.

My final visual will be a simple table that has all Codes listed in a column A and the count in column B. Something like this:

Is this possible? Thank you!

[HotChilli · Accepted solution]

The standard answer here is to split the column by delimiter (from the Power Query interface). Choose 'To Rows' and your data will be in a more structured format.

You can then use simple aggregations to get the figures you want.

[jose_cruzrodz]

Hi! Thanks for your reply. Yes, a couple minutes after I submitted my inquiry I found the "To Rows" option hidding within the Advanced area. I used it and as you suggested, it sorted the data in a way that I was able to properly manage and get the results that I needed. Excellent. Thanks!