Excel Auto Fill in Number range

[IUH_Telecom]

I just started porting telephone numbers between 4 different carriers.  When I get numbers from a telephone carrier the numbers are in a range.

Area Code

TN Range Begin

TN Range End

999	5555160	5555165
999	5556401	5556450

When I submit the port to another carrier they want each number listed individually, like this.

Area Code

TN Range Begin

999	5555160
999	5555161
999	5555162
999	5555163
999	5555164
999	5555165

Can excel look at the TN Range Begin and TN Range End and fill in all the numbers in between?  Doing this manually by putting the TN Range Begin in a column and then dragging down till I get to what the TN Range End works but is time consuming.

[#2 · Accepted solution]

@IUH_Telecom 

=DROP(REDUCE("",SEQUENCE(ROWS(B2:C3)),LAMBDA(x,y,VSTACK(x,SEQUENCE(INDEX(B2:C3,y,2)-INDEX(B2:C3,y,1)+1,1,INDEX(B2:C3,y,1),1)))),1)

With Office 365 or Excel for the web you can apply this formula.