Need to create a list with back filled data

I assume this will be done through a macro, but I have a list of items in a table:

Order number - order type - additional detail - line number

So example,

12345 - BA - 106078 - 03
12346 - CA - 106078 - 04

This basically lists all currently open orders, now I need the list to be backfilled according to the line number so it would have all the prior line numbers with the same data 01/02/03 ... 01/02/03/04.

There's thousands of open lines, so I need some assistance on how to populate the new table.

Edit: end result:
12345 - BA - 106078 - 01
12345 - BA - 106078 - 02
12345 - BA - 106078 - 03
12346 - CA - 106078 - 01
12346 - CA - 106078 - 02
12346 - CA - 106078 - 03
12346 - CA - 106078 - 04