Shift Schedule: change table from Name on X-axis to Shift Type - then populate Names

Hello,

My schedule program puts out shift type info (a, b or c) like this:

Date Bob Jim Sue
1 a b c
2 b c a
3 c a b
4 a b c

What is the best way to organize the info by Shift Type, with the names populated?

Date a b c
1 Bob Jim Sue
2 Sue Bob Jim
3 Jim Sue Bob
4 Bob Jim Sue

Thanks for your help, I'm just getting into the wild world of Excel...

There are 12 employees on 6 different shifts, 7 days/week. The employees want to look at the date, then move across the table to see the initials of each person who is filling in each shift for the day. Right now, it's organized as shifts listed under each employee name.