I have 2 columns shown below which is an independent dynamic array. In a sense, Dynamic List 1 is a dynamic array of each own and Dynamic List 2 is a dynamic array of each own.
Now in a 3rd columns, I'd like to concatenate this 2 dynamic array list into 1, with comma as the delimiter.
Below is my formula and it's not working correctly
|Dynamic List 1
||Dynamic List 2
||Desired Result (Dynamic Spill Array)
||Some Long Text
||Some Text, Some Long Text
||San Francisco, California