you're welcome. for your new requirements, try this in B1:
=OFFSET($A$1,COLUMN(A1)-1+FLOOR((ROW(A1)-1)/10,1)*3,0)