Create excel macro for simple spreadsheet

Need someone to help create a macro (in excel or kingsoft spreadsheet) that will expand a range of data. See attached file for example. I will have a range of seats in two columns, for example seats from 1, to 4 in the two columns. I need the macro to create three new rows so I will have a row for each seat. All the other data in the other columns should be copied over and duplicated in the new rows. So, I may have any number of seats in the range, and I need those to be expanded so each seat has it's own row in the spreadsheet. Please let me know if you have any questions