Lists from Multiple Selections [Table A] to Individual Rows [Table B]

[Christiaan_Huizer]

hi @Hendrik_TnB , this post may help you out:

everything is a list, even if all the items live in one cell. They way to ‘speak to each item’ is giving them a (virtual) number using Sequence() so you can reference them one by one using FormulaMap() and Nth().

I guess you can work it out seen your experience with Coda.

Cheers,
Christiaan

Separating Lists into new rows

hx @Aaron_Chupp , I am glad you tried out something. This works: Sequence(1,thisRow.[Line Items].Count()).FormulaMap([Helper Table (Line Items)].AddRow( [Helper Table (Line Items)].[Example-Christiaan],thisRow.[Line Items].Nth(CurrentValue),[Helper Table (Line Items)].[Order Number],thisRow.[Order Number], [Helper Table (Line Items)].TheName,thisRow.Name)) [image] What you see is the application of a virtual index to distribute values living in one cell. Enjoy your day, Christiaan