Lets say I have 2 columns with different values. I want to create a list of all possible combinations of the values in the 2 columns. is there a way to do that? For example, Column 1 has the values A, B, C and column 2 has the values 1, 2, 3. I want to create a list of the possible combinations that would include A1, B1, C1, A2, B2, C2, A3, B3 and C3.
Simple must know stuff
Lets say I have 2 columns with different values. I want to create a list of all possible combinations of the values in the 2 columns. is there a way to do that? For example, Column 1 has the values A, B, C and column 2 has the values 1, 2, 3. I want to create a list of the possible combinations that would include A1, B1, C1, A2, B2, C2, A3, B3 and C3.
Good info thanks
You bet
I'm working with spreadsheets again for the first time in two decades. Thanks for these, they're very helpful!
Glad you like them!
Nice and easy again thanks
Most welcome 😊
Love it
thanks