Get number between two numbers

[mussaenda]

Hi,

I would like to ask if it's possible to get the number between the two numbers? Please see photo below.

for example, the first red box

From Entry No : 57

To Entry No : 60

What I need is to show the numbers between them with the date same to the row of from entry no to to entry no

Entry No : 57, 58, 59, 60.

Instead of having one row, I will now have 4 rows.

Please let me know if this is possible. Thank you.

Sample:

From Entry No.       To Entry No.              Date

1                                    5                    31/05/2019

6                                    7                    01/06/2019

Expected:

Entry No.                 Date

1                             31/05/2019

2                             31/05/2019

3                             31/05/2019

4                             31/05/2019

5                             31/05/2019

6                             01/06/2019

7                             01/06/2019

Thank you.

Mia

[Zubair_Muhammad · Accepted solution]

@mussaenda 

Using Power Query, add following custom column>>then expand to new rows

={[From Entry No_]..[To Entry No_]}

[mussaenda]

It worked perfectly!

Thank you @Zubair_Muhammad