Apr 14 2020 12:55 PM
Hi.
Suppose you have the table below:
1 6
5 9
What should I do to make this table result in:
11 16 15 19 61 66 65 69 51 56 55 59 91 96 95 99
Explanation:
If:
1=A1, 6=B1, 5=A2 and 9=B2
then we can make:
11 (A1&A1) 16 (A1&B1) 15 (A1&A2) 19
(A1&B2) 61 (B1&A1) 66 (B1&B1) 65 (B1&A2) 69 (B1&B2) 51 (A2&A1) 56 (A2&B1) 55 (A2&A2) 59
(A2&B2) 91 (B2&A1) 96 (B2&B1) 95 (B2&A2) 99 (B2&B2)
Question: Is there a function that makes all of these results except for doing it one by one?