Forum Discussion
Solved
Count comma delimited data
Hello, I have a data dump whereby some fields can have more than one type in the same occurrence and other fields are multi-select which can give multiple categories in the same occurrence. I wan...
Hi,
I do not have a fancy way to solve this. All i can suggest is that we create two tables fro your source as shown below. I have done so by using the Split column > By rows feature of Power Query.
Hi,
Do not split the data by columns. SPlit it by rows as suggested in my previous post.
Just to clarify, from your sample data, the Types image should show an "a" of 3, correct? Because a occurs 3 times in your sample data?
yes that is correct. I just put together the example in excel quickly and mis-counted.
Bump.
