Month: February 2023

first column,then row

=OFFSET($A$1,COLUMN(A1)-1+(ROW(A1)-1)*4,)

first row then column

=OFFSET($A$1,ROW(A1)-1+COLUMN(A1)*4-4,)