Combination Generator

[Amine]

Hi everyone,
I have 2 columns with type EnumList and I want to create a virtual column that gives me all possible combinations.
For example:
Column1 has “A , B , C”
Colmun2 has “1 , 2”
Virtual column should have “A:1 , B:1 , C:1 ,A:2 , B:2 , C:2”
Is that possible with AppSheet ?
Thank you

[mateo]

Hi,
First option I thought about is concatenate( ) but it will probably connect all values from columns with ‘columns’ order. By ‘columns’ order I mean:
Col 1: A, B, C
Col 2: 1, 2, 3
concatenate( ) = A, B, C, 1, 2, 3
If that’s is enough no problem. If not, we have to dive deeper. I suppose there is a way to achieve that involving the key column.

[Marc_Dillon]

You might be able to modify this tip to do so:

Nested Action Loops Tips & Tricks 💡

I built this functionality today for a client, it seemed very share-worthy, especially since I wasn’t quite sure it would work until after I built it. There have been many posts about how to setup looping actions and how to automatically generate a number of new records. If you haven’t read those threads, you should start with those before reading this one. I may or may not come back to edit this post to link some of those other threads. Well here is one at least, since the community is trying …

Or you can do it as a GSheet formula:

Max Makhrov – 22 Dec 17

Generate All Possible Combinations for Columns in Google Sheets

Col1Col2DownloadsSample FileTechnologyGoogle SheetsRefers toArrayFormula TRANSPOSE SPLIT REPT CONCATENATE CHAR & (in a formula) IMAGE This was the question from StackOverflow. I need to populat…