| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Update 20191111 - changed share mode to comment only. Make a copy if you want to edit your own version. | |||||||
2 | ||||||||
3 | Column | |||||||
4 | 1 | 2 | 3 | 4 | 5 | 6 | ||
5 | Row | 1 | a | b | c | d | e | f |
6 | 2 | g | h | i | j | k | l | |
7 | 3 | m | n | o | p | q | r | |
8 | 4 | s | t | u | v | w | x | |
9 | 5 | y | z | ! | 1 | 2 | 3 | |
10 | ||||||||
11 | =INDEXMULTI($C$3:$H$7,{2,1,2,2,3,5},{2,5,6,6,3,3}) | |||||||
12 | ||||||||
13 | h | |||||||
14 | e | |||||||
15 | l | |||||||
16 | l | |||||||
17 | o | |||||||
18 | ! | |||||||
19 | ||||||||
20 | =transpose(INDEXMULTI($C$3:$H$7,{4,3,3,2,1,5},{5,3,6,6,4,3})) | |||||||
21 | w | o | r | l | d | ! | ||
22 | ||||||||
23 | Try it here: | Go to Tools --> Script editor to see code | ||||||
24 | t | e | s | t | ||||
25 | ||||||||