Please help!!

I'm having trouble developing concatenate formula that creates a unique identifier for each employee so I all have to do is paste the report in excel and my sales report vlookups will generate the data. My problem is I can't create a formula that accounts for the change in restaurant. I highlighted the cells with the restaurant change. Hopefully you guys can help.please help.xlsx