Merging multiple lines if one range selcted

[sjordan765]

Hi All, so I have a weird question. 

I have created a small hotel template for reservations 

I have as you can see below created dates and a range of selections

I was wondering how or what formula (if any) i can use to 

when I enter the number of nights the

guest name

booking source

villa size

cost per night and

total cost cells all merge automatically so i don't have to merge them each time one by one

then what formula do i put in to auto add the cost per night to the number of nights'

sorry if this is confusing but it will help me so so very much 

thanks

Steve

[#2]

@sjordan765 

Showing results for template for reservations

from Microsoft

Reservation Templates

On this page, we have assembled 3 Excel templates to help you with reservation, booking, and inventory. The upper link is a non-Microsoft websites. Watch out for ads on the sites that may advertise products often classified as a PUP (Potentially Unwanted Products). 

[#3]

@NikolinoDE 

hey

thanks for the reply where do i find the link to this template

[#4]

Find download link below

https://2excel.s3.amazonaws.com/planning/reservation/Booking_Reservation_Calendar.zip?X-Amz-Content-...