Hey guys,
To set the scenario, I have a list (column) of product codes, and around 200 column headers of customer names. The values consist of how many of those products each customer has.
I want to filter my view of the columns by referring to another document that lists characteristics for each customer, i.e. the sales person in charge of them. Ideally, I want to refer to these and filter columns for i.e. Sam Jones.
Is there a way to do this without having to transpose all of my column headers into rows, appending the owner names and filtering that way?
Thanks in advance!