Copy reference data skip blanks

[Silkcut]

Hi, I am trying to link /reference the main data which contains monthly data but has fixed blank columns to another work sheet. I tried offset however the formula doesn't move skip the cells i want to refer to in order. See attachment as reference.

Would appreciate any help/suggestions.

Thanks, Wez

 

[oldbrewer]

on the receiving sheet in C2 =maindata!B2 and in D3 maindata!d2 etc

 

[Silkcut]

on the receiving sheet in C2 =maindata!B2 and in D3 maindata!d2 etc

Thank you but I want to copy across the sheets skipping the blank cell.

 

[oldbrewer]

on the receiving sheet in C2 =maindata!B2 and in D2 maindata!d2 etc

D3 was a typo - it does skip blanks but you need to enter it manually - 3 years is only 36 entries

otherwise an offset approach would be needed probably with a helper row of 3....5....7 etc