How to create new cells in sheet 2 by using all cells in sheet 1 added to each other by "&" or sth?

Copper Contributor

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?

0 Replies