Create new rows based on From and To values in two columns

[DanJohansen]

Hi, I have a table which looks like this:

Nr.	Kontoart	From Account	To Account
100	Managementfee	10110	10113
110	Lejeindtægter	10121	10124
120	Øvrige indtægter	11210	11212

and I would like it to end with this result:

Nr.	Kontoart	Account
100	Managementfee	10110
100	Managementfee	10111
100	Managementfee	10112
100	Managementfee	10113
110	Lejeindtægter	10121
111	Lejeindtægter	10122
112	Lejeindtægter	10123
113	Lejeindtægter	10124
120	Øvrige indtægter	11210
121	Øvrige indtægter	11211
122	Øvrige indtægter	11212

any Ideas for that will be appreciated very much! 

[DanJohansen]

Thx Pete! You are a life saver! Whereever you are, have a nice day! 😄

[BA_Pete · Accepted solution]

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

[DanJohansen]

Hi Pete! Thx for answering and yes, the two columns are numerical, but I get this error:

[BA_Pete]

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