Hi -

Need assistance with an excel file. What I'm trying to do is help the acctg department simplify a manual process for invoicing some of our hotels that we work with. What I'm trying to do is have all of the rows for the same hotel name to be on one line so that we can do a mail merge by simplifying the process. I'm open to any suggestions. Here is a sample of the data - there are a lot more records but I will need for this to also calculate the final commission due to us per hotel.

Thanks in advance for the help!

Copy of Missing Data Report 6-5 thru 6-12_NEWSAMPLE.xlsx