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.

Hi!
Exactly. If there are multiple sets of blackout dates for a hotel, I'd like the data from A to G to be copied into the inserted rows and for each row to only display one set of blackout dates (start and end). Each row, including the first row, would only display one set of start and end dates.

Yes! This is so great! So sorry to do this, but I realized that i omitted a couple of columns that need to be incorporated - can I just change the column names in the formula?

In case you can help, I've attached the revised spreadsheet and desired output on tab 2. I need a blank column in column C and I am supposed to have a field before each set of start and end dates with the Name of the blackout range. The new columns are highlighted in Yellow.

I cannot believe how simple your macro formula looks, I was all over the place before I came to this forum. THANK YOU!!!

Perfection! I can't thank you enough. You have saved me so much time and stress. Have a great day.