How Can I move Raw Data Into Separate Columns

Hi, I have some lab data that I need to organize. I have two probes collecting data points and they measure at different index cycles. I would like to take the raw data and organize them into separate columns where the data from the two probes are separated out based on the index cycle. For example all the data collected on index cycle one are separated out from the data collected in index cycle 5 and so on. I have included an excel file with some sample data to better illustrate what I am trying to achieve.

I tried using VLOOKUP to separate the data based on the index cycle but it is not giving me the results I want. Some columns are giving me wrong values. Is there a simpler way to solve this problem?

Thank you.

You could try this as a start. It's an array formula, so instead of entering the formula in the cell using the ENTER key, hit Enter while holding the Shift and Ctrl keys down. If done correctly the formula should show brackets {} around it. Enter this formula in cell E6 and you can copy it down as far as needed and then copy it over to F6 and down. You'll need to change the "$E$4" in the formula when copying it farther over.

=IFERROR(INDEX(A$6:A$26,SMALL(IF($C$6:$C$26=$E$4,ROW($C$6:$C$26)-ROW(INDEX($C$6:$C$26,1,1))+1),ROW()-5)),"")

Thank you very much! Both solutions worked very well!