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?
Bookmarks