Adding new lines using the information present in existing lines

[srk0609]

I have attached excel file with 2 sheets
1) Sheet Name "Data" - Which has existing lines of Data
2) Sheet Name "New Lines" - Which has existing lines of Data highlighted in Green. I want to to know how can I generate new lines that are not highlighted using existing lines

Logic -  In first highlighted line for Seg1 low = 39 we have Seg 4 low = 10120 and Seg 4 high = 10122. So, I want to generate 3 new lines having rest of columns with same value but only Seg 4 low, Seg 4 high should change. 3 new lines cos value between 10120 - 10122 include 10120,10121,10122

Line 1)Seg 4 low = 10120 and Seg 4 high =10120
Line 2)Seg 4 low = 10121 and Seg 4 high =10121
Line 3)Seg 4 low = 10122 and Seg 4 high =10122

Logic -  In second highlighted line for Seg1 low = 40 we have Seg 4 low = 10121 and Seg 4 high = 10124. So, I want to generate 4 new lines having rest of columns with same value but only Seg 4 low, Seg 4 high should change. 4 new lines cos value between 10121 - 10124 include 10121,10122,10123,10124


Line 1)Seg 4 low = 10121 and Seg 4 high =10121
Line 2)Seg 4 low = 10122 and Seg 4 high =10122
Line 3)Seg 4 low = 10123 and Seg 4 high =10123
Line 4)Seg 4 low = 10124 and Seg 4 high =10124

[binuacs · Accepted solution]

@srk0609 one way of doing this with the generate rows tool

[srk0609]

Thank you for the solution @binuacs. It worked