Duplicate rows based on year field

[Anonymous]

Hello 🙂

I have a year field where some rows are written 2027-2030, I want to know if it is possible to convert this row to multiple rows with duplicating the same row but with drill down year.

I want to have:

2027 .................

2028 ...............

2029 ....................

2030 ..................

Is it possible ?

[amitchandak · Accepted solution]

@Anonymous , You need to split this column by delimiter

when second one is blank copy the values from the first one

Then use List.Generate to get the year between the two columns and expand the list