Seat location range to individual rows per seat

Hello!

I have a list of seat locations in a range. Section 100, row 1 seats 3-4 for example. I need those to be listed as one seat per row. 100 1 3, 100 1 4, instead. Attached is an example. Any ideas?

Thank you!

Helper columns

in E2

=D2-C2+1

copy down

in F2

=SUM($E$1:E2)+1

Copy down

In J2

=INDEX(A$2:A$6,MATCH(ROWS($1:1),$F$1:$F$6))

copy to K

in L2

=INDEX($C$2:$C$6,MATCH(ROWS($1:1),$F$1:$F$6))+COUNTIF($K$2:K2,K2)-1

As you have 365 I am sure there will be a better solution