Forum Discussion
Need help sorting data in random columns
What will be desired result for your sample, do you need only sorting or filtering as well?
Example would be:
Product 1 Product 2 Product 3
Company Company Company
Town Town Town
Company Company Company
Town Town Town
Company Company Company
Town Town Town
SergeiBaklan I would like the end result to be a list of all companies that have each product that I can pull into word to create a directory that is sorted by product (showing each company that has it). I hope that makes sense..
Still not clear. It will be separate table like
product 1 | company 1 | company 3
product 2 | company 2 | company 3
etc
or
you select the product from drop-down list and list of all companies will be generated in one column;
or
something else
The problem is that each company's info., including it's town, is spread across random columns and I need to be able to sort/filter all companies that have a particular value/product regardless of which column that value/product sits in.
So I want to pull all companies that have Product 1 and create a list that shows Product 1 and all Companies that have Product 1 (in their random columns), and I need to have all of the company's corresponding states with them.
End result in word would be:
Product 1
Company & State
Company & State
The town has to stay with the state.
