Forum Discussion
Solved
Group multiple columns into single filter
Hi, Please see below. I have 3 columns with name of companies that can repeat row to row. How do I create a table with column 1 and column 2 info that can be filtered by by name of the companies from column 3, 4 and 5? I'd appreciate your help!
Hi Reh
You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.
Regards,
Cherie
1 Reply
Hi Reh
You may click the project # and project cost columns and then use 'Unpivot other columns' in query editor.Then filter out the blank values.Use the value column as slicer to get the visual.
Regards,
Cherie