I have a database of event attendees. They are registered for 1-6 events over the course of a day. I would like to create a report that will generate their personalized schedule so it looks something like this:
Time 1 - Session 1
Time 2 - Session 2
Time 3 - Session 3A
Time 4 - Session 4B
Time 5 - Session 5
Time 6 - Session 6
Easy enough.
My problem lies in generating the report for those people who are not attending all sessions. I want to collapse the white space left behind by empty fields and I am drawing a complete blank. If the person is only attending Sessions 2 and 5, I want those to appear in the 1 & 2 position with the white space below.
I feel like there's one way I could do it by layering fields and an awful lot of conditional formatting... if there's an easier way to do it, I'd very much appreciate someone letting me know.
THANKS!