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.
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.
