Need help sorting data in random columns

Question

I have data sorted by company across rows but not in sorted columns. How can I sort all companies that have the same data in red to create a list? Do I have to create a separate column for each in red? I have 125 different values for red columns, and if so how can I automate that?

See example:

Company1	state	product 1	product 5	product 6	product 8
Company2	state	product 2	product 6	product 8	product 9
Company3	state	product 1	product 2	product 5	product 7	product 9

sergeibaklan · Answer

ezpzz&nbsp;
What will be desired result for your sample, do you need only sorting or filtering as well?

ezpzz · Answer

SergeiBaklan&nbsp; 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).&nbsp; I hope that makes sense..

ezpzz · Answer

SergeiBaklan&nbsp;SergeiBaklan&nbsp;&nbsp;Example would be:&nbsp;Product 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Product 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Product 3&nbsp;Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CompanyTown&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Town&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TownCompany&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CompanyTown&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Town&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;TownCompany&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Company&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;CompanyTown&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Town&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Town

sergeibaklan · Answer

ezpzz&nbsp;
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&nbsp;

ezpzz · Answer

SergeiBaklan&nbsp;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.&nbsp;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.&nbsp;End result in word would be:Product 1Company &amp; StateCompany &amp; State&nbsp;The town has to stay with the state.

Forum Discussion

Need help sorting data in random columns

8 Replies

Resources