A B C D E F G 1 a 2 a b c d 2 b 4 2 4 6 8 3 c 6 10 12 14 16 4 d 8 18 20 22 24 5 a 10 26 28 30 32 6 b 12 7 c 14 8 d 16 9 a 18 10 b 20 11 c 22 12 d 24 13 a 26 14 b 28 15 c 30 16 d 32
Table 內每個格的 formula 是
=OFFSET($B$1,(4*(ROW()-ROW(D$1)))+(COLUMN()-COLUMN($D1)),0,1,1)