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