Forum Discussion
Create new rows based on From and To values in two columns
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!
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
4 Replies
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
Thx Pete! You are a life saver! Whereever you are, have a nice day! 😄
