Referencing Every other row

I am having trouble coming up with a formula that will reference every other row in a set of data. If the first column and row has a 1 in it I want all the data to the right to be displayed. First Column second row has a 2 then no data should be displayed. So that there is one table with just the data from 1 and not from 2. There are 14 columns to the right of the first column. I'll attach an example. The table is on the tab RI Ladder LC-POS_CS starting in A143, the new table can be displayed anywhere. I just need help with the formula.

Thanks,

Jay

Your sample does not match your description. There is nothing in cell A143. I suggest you enter dummy data in your sample sheet showing what you want to achieve (ie assuming the formula worked)

Sample filename a b c d e f g h i j k l
1 inst-31711 ltq3pos20120411_plasmaa5_01 0.7266 0 1.1751 1.3879 1.5763 1.9177 2.2767 2.6512 0 3.007 3.5654 5.2051
2 inst-31712 ltq3pos20120411_plasmaa5_02 0.6907 1.1406 1.1191 1.3338 1.5133 1.8601 2.2171 2.5872 2.7497 2.9407 3.5042 5.1675
1 solv-26086 ltq3pos20120411_plasmaa5_03 0.7261 0 1.1759 1.3879 1.5758 1.9224 2.2798 2.6502 2.8038 3.0114 3.5676 5.2078
2 prcs-43757-prcs-02 ltq3pos20120411_plasmaa5_04 0.6902 1.0811 1.1179 1.3367 1.5152 1.862 2.2157 2.5826 2.727 2.9398 3.5115 5.1708
1 mtrx2-02258-mtrx2-02 ltq3pos20120411_plasmaa5_05 0.7114 1.1404 1.1808 1.3872 1.571 1.9219 2.2767 2.6535 2.7969 3.0131 3.5663 5.2042
2 meta-50596-lc-01 ltq3pos20120411_plasmaa5_06 0.6738 1.0833 1.1169 1.331 1.5118 1.8586 2.2129 2.5827 2.7271 2.939 3.5078 5.1667
1 meta-50597-lc-01 ltq3pos20120411_plasmaa5_07 0.7096 1.142 1.1742 1.3884 1.5708 1.9151 2.2769 2.6474 2.7998 3.0099 3.5643 5.2013
2 meta-50598-lc-01 ltq3pos20120411_plasmaa5_08 0.677 1.0794 1.1205 1.3343 1.5099 1.8549 2.2151 2.5832 2.7252 2.9368 3.5062 5.17

here is a simplified version, see attached. sorry about that last post.

Why don't you format your data as a table (INSERT\TABLE) and then filter on the "1s" in column A?

it is a repetative task, with the initial data I would like to simply paste from a database into excel and using the reference table that picks out the samples that are run on column 1 and column 2. And then create a retention time plot using dynamic charting for each internal standard. this way all i have to do is paste and the charts are generated. I already have this set up on a 1 column system but i cant recall the formula that i could use for this 2 column system.