Only list values - NOT blanks

Hi there,

I'm hoping someone out there can help me with this, as I'm out of ideas now!

I am working on a rota. Unfortunately we have 3 staff teams and multiple part-timers all on a 3 (or 8 week) rolling rota, so this is proving somewhat complicated. I've reached the last hurdle (I hope), which is presentation.

Currently the rota outputs a name or a "" for each member of staff that could potentially be on shift that day, as we have over 100 staff, this means a lot of ""s. I would like a formula which looks at each day, and lists the populated cells only. Due to the poor speed of our systems, macros are not an ideal option.

All help on this will be most gratefully received!

Kim