Forum Discussion
stefantaust
Helper I
Helper Ifilter across multiple columns
Hello, how can I filter the data and display all that contain an "X" and write the data in a new Table Regards Stefan
There are various methods.
Try this methods ...
In Power Query select the Check ID , Status and Bereich column
Then Transform > Unpivot > Unpivot Other columns
Then filter the rows that have "X"
Learn how here
https://learn.microsoft.com/en-us/power-query/unpivot-column
speedramps
Super User
Super UserThere are various methods.
Try this methods ...
In Power Query select the Check ID , Status and Bereich column
Then Transform > Unpivot > Unpivot Other columns
Then filter the rows that have "X"
Learn how here
https://learn.microsoft.com/en-us/power-query/unpivot-column