Multiple Columns Search and Return Corresponding Values to A List

[mikedunn]

[FONT=&quot][/FONT][FONT=&quot]
https://www.dropbox.com/s/09ld766ywu8bc04/EXCEL TEMPLATE POLAR BEARS.xlsx?dl=0

Hi I require data to be returned in columns from the following[/FONT]

[FONT=&quot]I need the names to be returned in one long list split into the seven different material options[/FONT]

[FONT=&quot]Each row on All Orders page may contain 1 to 7 different material/name combinations[/FONT]
[FONT=&quot]Each row can vary[/FONT]
[FONT=&quot]I need the formula to go down 1000 rows[/FONT]
[FONT=&quot]The results must contain no N/A or Value or blank results[/FONT]
[FONT=&quot]
See Results Sheet for how i need the data returning, all data is in the[/FONT][FONT=&quot] All Orders Sheet [/FONT]

------------

[FONT=&quot]in Columns E To R is the data set (All ORDERS)[/FONT]

[FONT=&quot]Column E is material Type (One of 7 Available) Column F is Name G Material Type H is Name and so on[/FONT]

[FONT=&quot]I require on a new sheet (Results)[/FONT]

[FONT=&quot]7 Columns one for each material type[/FONT]

[FONT=&quot]If the material type has been select i need the formula to return the name in the correct column on the results page. So from the entire data set i would have the 7 columns with a list of names under each material[/FONT]

[FONT=&quot]I can do this manually by filtering the columns E, then G, then I etc) and copy and paste the data into the columns but i want to do this automatically

[/FONT]Thanks in advance if anyone can help