I have a table column with multi-select and input new items on. I am trying to extract the different cell values of that column into another table in individual rows. For eg in Table 1 multi select column I have options A and B selected. In Table 2, I would like to have Option A in one row and Option B in the next row. Thanks.
Thanks for the solution! Is it possible to have the values work more like a lookup instead of an action? Using actions requires the automation to delete all rows in the table and then run the formula to prevent duplicates.
That said, in this case I don’t think you should need this functionality if your doc is representative of your actual use case. You’ll be better off making a table called, “Orders” where you order one product at a time, and then you can batch those by clicking the “order” button which will assign all of them the same order id.