Sorry about the cross post but I'm getting desperate...

row 1 contains headers. col A and C contain values. I need to populate Col B
with values like the following

B2 needs to read R2C3
B3 needs to read R2C4
B4 needs to read R2C5
B5 needs to read R3C3
B6 needs to read R3C4
B7 needs to read R3C5
B8 needs to read R4C3
B9 needs to read R4C4
B10 needs to read R4C5

etc...

I was given...
=OFFSET($C$4,INT((ROW(A1)-1)/3),MOD(ROW(A1)-1,3))

But it's not working because of the values that I have in columns A and C.


Any and all help is greatly appreciated.