Copying every nth Column from the same row

It is FAR easier to standardize your data even if you continue to record it in this format, you can always just create a "standardizedDATA" tab then have super simple formulas from the standard data.
People dont realize how simple things can be when they clean and standardize their data into one tidy dataset where each data dimension has its own column and each measure has its own column.

With all that being said you can use a simple index(match()) formula to get what you want.

Copy and paste formula in B36 then drag to the right:

Please Login or Register  to view this content.

Copy and paste formula in B37 then drag to the right:

Please Login or Register  to view this content.

Try this for the AVG...

Assuming you enter the first formula in cell B36:

=INDEX($B17:$Z17,COLUMNS($B36:B36)*3-2)

Copy across as needed. Adjust the end of range Z17 to suit.

Use the same syntax for the AVG Weight but adjust for the proper range.

B35 Formula:-

Formula:

Please Login or Register  to view this content.

B36 Formula:-

Formula:

Please Login or Register  to view this content.

B37 Formula:-

Formula:

Please Login or Register  to view this content.

Then fill right.