Forum Discussion
Create new rows based on From and To values in two columns
Hi DanJohansen ,
Assuming your From/To columns are in numerical format, you can add a custom column like this:
= {[From Account]..[To Account]}You can then expand the nested list column to new rows.
If your original columns aren't numerical, then you'll need to wrap the column references in Number.From:
= {Number.From([From Account])..Number.From([To Account])}Pete
Hi DanJohansen ,
Assuming your From/To columns are in numerical format, you can add a custom column like this:
= {[From Account]..[To Account]}
You can then expand the nested list column to new rows.
If your original columns aren't numerical, then you'll need to wrap the column references in Number.From:
= {Number.From([From Account])..Number.From([To Account])}
Pete
Hi Pete! Thx for answering and yes, the two columns are numerical, but I get this error:
Hi DanJohansen ,
Apologies, I updated my answer with the curly braces that are needed right after I posted, but you'll need to refresh your browser (F5) to see (basically, put curly braces around the whole thing).
My bad.
Pete