Forum Discussion
Solved
Filter rows on multiple conditions with different values
Hi everyone, I've been trying to figure out a problem, looked at dozens of related questions, but wasn't able to find the right solution yet. In the displayed Excel table, I have simplified my d...
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.
Hi jdbuchanan71,
Thank you very much for your reply!
Yesterday I tried applying your suggested solution. Creating a pivot column worked and I did indeed show the status values for each task stage.
However, due to the unique values in other columns, the list will show individual client numbers multiple times. I will try to figure out if this causes a problem or that I can fix this by using other smart filter options.
I will let you know if your solution worked!
Regards