Forum Discussion
Search Value on Multiple Columns and return all associated
Hi all, I have a table populated with names in different columns. Each row represents salesperson names who worked together on a specific date. My expected result is a list of names who worked t...
parry2k
Super User
Super UserGFRO the best approach is to unpivot your data, salesperson 1, 2, 3 on rows and you can always visualize using matrix visual to show salesperson 1, 2, 3 on columns, but it will not require any complex calculation to find Sarah. Then you can easily search for the salesperson and it will show wherever it exists.
It is important to shape the data in a way that removes the complexity. I hope it helps.
