Pulling Specific Conditions from Large Result Table

[NucE]

So I am a engineer running a test that usually has 150 conditions. Every odd condition is a "equilibrium condition" that is meant to stabilize the test rig between the even conditions. The even conditions are the actual results I want to look at and evaluate.

I've been trying to use a IF functions or Vlookup to extract the even conditions into a separate worksheet automatically. But I can't seem to figure out how to grab the information I want automatically.

So basically I want to take all of the corresponding values for condition 2 and put them in a separate worksheet. Regardless of how long it is or how long the other conditions are. Sometimes the data points are taken at different times and so having a template that works regardless of the amount of data would be amazing (ie conditions being 6 rows or 30 rows)

I included a sample of what it would look like. I just made it really fast. I'll probably get into trouble for posting a real thing but this is the structure. I just need to figure out a way to automatically pull the even conditions to new tabs. The sample has a few but in the real one itll have 100s of conditions.

*** My idea is to have a "template" or blank file with a lot of empty worksheets and when I paste in the new data into the "All Data" worksheet, it automatically grabs the right conditions and put them into corresponding worksheets. From there graphs, should be able to plot themselves for evaluation since they will just grab the data from each condition worksheet.

Sorry if this seems confusing or if my lack of Excel knowledge offends you

Thanks for your help!!! I've watched hours of tutorial videos and I can't seem find a easy way to do this automatically.

Capture.PNG

[dredwolf]

A sample workbook is of more use
And BTW, Welcome to the forum

[azumi]

Pls check the file attach


Azumi

[ramananhrm]

I have compressed few conditions.
Please try this file.

[NucE]

Thank you everyone for your help! Both seemed to do what I was looking for and I learn a lot from this. I greatly appreciate the help guys. I gave you all high ratings as you deserve.