Hello,
I have guest name in column A, and all the dates as header rows for the date the guest stayed at the site. The "c" in each cell indicated that person stayed on that specific date, for example person G, stayed from January 2 and onwards.
Below is my input:
I would like my output to have a new column like below columns in blue with a Check In and Check Out date where it takes the first "c" in the range of row per guest to bring the header row as check in date and the last "c" as check out date. Loop is also required to be built in that would be great, in case if there is a break in between.
Any help would be highly appreciated!!
