Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter based on multiple columns

I have a Data table that looks like in the picture below. I have one column with unique IDs and one column with a text string. The text string contains different combinations of a code. I want to be ...
Need Help
  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , if you have only the first two columns. My advice would split the second column  into rows in power query

    Split Column Power Query: https://youtu.be/FyO9Vmhcfag

amitchandak's avatar
amitchandak
Super User
4 years ago

Anonymous , if you have only the first two columns. My advice would split the second column  into rows in power query

Split Column Power Query: https://youtu.be/FyO9Vmhcfag

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you so much! That works perfectly!