Forum Discussion
Find multiple strings in 1 row, even duplicates
I'm struggling with to come up with an working formula. that will count/find the given set of string in a row. I either get no result, or 1 result. e.g. row Data A, Data B, Data A, Data C, Jo...
This should be fairly easy in Power Query. As fas as I understand, you have one field with the text-string in it. Split this into columns, based on the comma seperator. Then pivot your data and group by where you count each Data X.
Let me know if it works!
Forgot to mention, it's 1 column row, of many columns. Wouldn't your way create a-lot of duplicates?
Remove duplicates before splitting then :)
Do you have a screenshot or a simplified exampje of your data?
Hi SP4NU7CH,
Do you have the data like below?
And you want to get the output below?
I'm still a little confused about your scenario, could you please share your data sample and your desired output, so that we can help further investigate on it?
Best Regards,
Cherry
