Forum Discussion
Filter rows on multiple conditions with different values
We can merge the status and employee columns into one with a delimiter (I like to use the pipe | ).
Then pivot on task name, split by delimiter and finally rename the columns to end up with this.
I have attached my sample file for you to look at the steps in the query editor.
The cleanest way I can think to do this is to use PowerQuery to pivot the [Task stasus] column so you have a column for each task name. Then you can apply a slicer to the different columns.
Hi jdbuchanan71,
I had a better look at applying your suggestion. Unfortunately I'm presented with a problem, because of another column. In my example I left this column out, because I didn't think it would have an effect on this situation, but it does when I apply your suggestion.
As you can see in the example below, there is also a column 'Task employee' and the values are different for each task. When I pivot the Task column, it then gives me multiple rows with null values, because it isn't able to merge due to the Task employee values differentiating.
Is there a way to solve this?
My guess is I could create columns such as 'A1 employee' and 'A4 employee', but if the task column is already pivotted, how would I get the correct data in these columns?
Thank you very much again for helping out.
Regards