Kindly help with the attached excel file. It containts two sheet. I would like to group the guest name by Hotel Name in Sheet1 based on the hotel code. The Sheet2 contains the Hotel Name with it corresponding Hotel Code.
Any help would be very much appreciated. You may used the file and upload it with the formula.
Many thanks in advance