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) |
Ontario |
Canada |
Ontario, Canada |
Some Text |
Some Long Text |
Some Text, Some Long Text |
San Francisco |
California |
San Francisco, California |
Bookmarks