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

%3CLINGO-SUB%20id%3D%22lingo-sub-1307055%22%20slang%3D%22en-US%22%3EHow%20to%20create%20new%20cells%20in%20sheet%202%20by%20using%20all%20cells%20in%20sheet%201%20added%20to%20each%20other%20by%20%22%26amp%3B%22%20or%20sth%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1307055%22%20slang%3D%22en-US%22%3E%3CP%3EHi.%3C%2FP%3E%3CP%3ESuppose%20you%20have%20the%20table%20below%3A%3C%2FP%3E%3CP%3E1%206%3C%2FP%3E%3CP%3E5%209%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20should%20I%20do%20to%20make%20this%20table%20result%20in%3A%3C%2FP%3E%3CP%3E11%2016%2015%2019%2061%2066%2065%2069%2051%2056%2055%2059%2091%2096%2095%2099%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExplanation%3A%3C%2FP%3E%3CP%3EIf%3A%3C%2FP%3E%3CP%3E1%3DA1%2C%206%3DB1%2C%205%3DA2%20and%209%3DB2%3C%2FP%3E%3CP%3Ethen%20we%20can%20make%3A%3C%2FP%3E%3CP%3E11%20(A1%26amp%3BA1)%2016%20(A1%26amp%3BB1)%2015%20(A1%26amp%3BA2)%2019%3CBR%20%2F%3E(A1%26amp%3BB2)%26nbsp%3B61%20(B1%26amp%3BA1)%2066%20(B1%26amp%3BB1)%2065%20(B1%26amp%3BA2)%2069%20(B1%26amp%3BB2)%2051%20(A2%26amp%3BA1)%2056%20(A2%26amp%3BB1)%2055%20(A2%26amp%3BA2)%2059%3CBR%20%2F%3E(A2%26amp%3BB2)%2091%20(B2%26amp%3BA1)%2096%20(B2%26amp%3BB1)%2095%20(B2%26amp%3BA2)%2099%26nbsp%3B(B2%26amp%3BB2)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EQuestion%3A%20Is%20there%20a%20function%20that%20makes%26nbsp%3Ball%20of%20these%20results%20except%20for%20doing%20it%20one%20by%20one%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1307055%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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