Macro - copy and insert multiple rows

Hi! Just joined this forum - very excited that someone may be able to help me with my issue.

I work with hotels and I am trying to create a macro that breaks up data from one row into multiple rows. In my original spreadsheet, each row has a hotel name, code, city, country, etc. Then it has a list of blackout start and end dates. The max number of date ranges is 10.

I want the macro to look at the number of blackout ranges for each hotel and then insert the same number of additional rows beneath the first row. There should be a separate row for each set of blackout dates.

I've attached a sample: Tab 1 has my starting data and tab 2 has the desired output. If the hotel has no blackout dates, no new rows would be added. If there is only one blackout date, no new rows would be added either.

Any suggestions would be greatly appreciated! Let me know if there are any questions.