I am trying to manipulate a fairly simple weekly schedule.

On Sheet 1, column A contains names, Row 1 contains Days of the week. The
cells in column B contain a number indicating the shift that the person is
supposed to work. It looks like this:
Sun
Joe 6
Bill 7
Bob 7
Frank 11

On Sheet 2, I want to turn this data around so that the column headings are
the shift time and underneath there is a list of people on each shift. It
should look like:

6 7 11
Joe Bill Frank
Bob

Unfortunately, there may be a different number of people on each shift each
day, so a simple sort isn't enough. Note that each day will have it's own
sheet (2-8) drawing its' data from the proper column.

How do I do it?