Excel Pulling information from a data dump

Hi all,

I am using excel 2013. My issue is as follows:

1) I have an excel file with multiple sheets.
2) Sheet 1 has the data dump, Example:

vendor supplier code CLUTCH FASTENER
3 DIMENSIONAL X
3M AUSTRALIA PTY LIMITED X
3M SOUTH AFRICA PTY LIMITED X
3M THAILAND LIMITED X
3POINT MACHINE
A AND E KELLER GMBH AND COMPANY C6R9A X
A B HELLER INCORPERATED B3513E0
A KAYSER AUTOMOTIVE SYSTEMS GMBH

The above is a sample of the first few rows.

3) There are over 2000 rows of information. I need to make a tab label it clutch and then pull information from the data dump. I need to make a tab for each commodity listed in sheet1 the data dump (~20). So the next tab would be labeled Fastener. Then, I would need to look at the Clutch column in the data dump tab (sheet1) and determine all the rows that have and X in the clutch column. For every row that has an X I would need to pull the Vendor name associated with that row and put it in one a column in the clutch tab and I would need to pull the supplier code from that same row in sheet 1 and put it in another column in the clutch tab.

Any help on how to do this would be great!
I have attached the file I am working on to this post.

Thanks

Basically same thing that you would get from using autofilter then?

Here is something. I made formulas for both columns and since you have lots of data and these are arrayformulas it's a bit heavy to calculate. If you plan on extracting mor columns of data I would use basically the same formula to just get the row nr and then use a basic INDEX to get the data.

These are array formulas, they have to be entered with Ctrl + Shift + Enter. Just fill down until you get the "-". Copy the whole sheet and change the title in A1.