Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Data manipulation
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with data not getting plotted | Excel Discussion (Misc queries) | |||
Help with data not getting plotted | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Charting data ranges that change | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |