Forum Discussion
jps_HHH
Helper II
Helper IIcount info separated by comma
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 L...
Hi, jps_HHH
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
PhilipTreacy
Super User
Super UserHi, jps_HHH
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