Combine text in multiple cells if not blank

I am trying to write a formula that will combine text from 4 cells if if they are not blank. For example, I have 4 columns titled Sales Rep 1, 2 3 and 4. In the cells below are the names of the sales reps. If sales rep 1 is empty then the result will be empty. That is an easy formula to write. If Sales rep 2 is empty it will default to just sales rep 1. This too is an easy formula. If sales rep 3 is empty then it defaults to combine sales rep 1 and 2. I was able to make that work too. The problem is adding a 4th sales rep. See attached excel to see what I mean.

Thanks in advance for your help.

Hope this works

One way...

=IF(COUNTA(B2:E2)=0,"",MID(IF(B2="","","/"&B2)&IF(C2="","","/"&C2)&IF(D2="","","/"&D2)&IF(E2="","","/"&E2),2,500))

Perfect. That worked great as I was hoping to use a non-array formula as I also need to use it in my Google Sheets file. Thank you!

Thank you. I was looking for a non array formula but I see yours works too. Thank you.