Spreadsheet: 118443d1313691177-excel-2007-converting-multiple-columns-to-multiple-rows-transpose-example
Sheet: Data Sheet

instructional header |  | Instructional header |  |  |  |  |  |  |  |  |  |  |  |  |  |  | instructional header |  |  |  |  |  |  |  | instructional header
 |  | course 1 | course 2 | course 3 | course 4 | course 5 | course 6 | course 7 | course 8 | course 9 | course 10 | course 11 | course 12 | course 13 | course 14 | course 15 | course 16 | course 17 | course 18 | course 19 | course 20 | course 21 | course 22 | course 23 | course 24 | course 25 | course 26 | course 27
Shop | User | DATE C/W | DATE C/W | DATE C/W | DATE C/W | DATE C/W | DATE C/W | DATE C/W | DATE C/W | DATE C/W | DATE C/W | DATE C/W | Done | Done | Done | Done | Date Due | Date Due | DATE C/W | Date Due | Date Due | Date Due | Date Due | Date Due | Date C/W | Date C/W | Date C/W | Date C/W
WMJD | Name 1 | 2011-03-22 00:00:00 | 2011-03-09 00:00:00 | 2011-05-04 00:00:00 | 2011-06-13 00:00:00 | 2011-06-29 00:00:00 | 2010-07-29 00:00:00 | 2011-05-04 00:00:00 | 2010-08-02 00:00:00 | 2010-09-23 00:00:00 | 2011-07-06 00:00:00 | 2010-08-02 00:00:00 | YES | YES | YES | YES | 2012-06-07 00:00:00 | 2011-09-23 00:00:00 | YES | 2011-09-23 00:00:00 | 2011-12-08 00:00:00 | NA | NA | NA | 2010-09-23 00:00:00 | 2010-09-23 00:00:00 | 2010-09-23 00:00:00 | 2010-09-23 00:00:00
WMKD | Name 2 | 2010-10-29 00:00:00 | 2011-03-31 00:00:00 | 2011-03-31 00:00:00 | 2011-06-23 00:00:00 | 2010-02-24 00:00:00 | 2010-07-27 00:00:00 | 2011-03-31 00:00:00 | 2010-07-27 00:00:00 | 2010-08-15 00:00:00 | 2010-07-27 00:00:00 | 2010-08-11 00:00:00 | YES | YES | NO | YES | 2012-03-30 00:00:00 | 2011-10-26 00:00:00 | YES | 2011-10-26 00:00:00 | 2011-08-15 00:00:00 | NA | NA | NA | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00
WMJB | Name 3 | 2010-11-17 00:00:00 | 2010-09-21 00:00:00 | 2010-09-21 00:00:00 | 2011-08-15 00:00:00 | 2010-11-16 00:00:00 | 2010-07-29 00:00:00 | 2010-09-21 00:00:00 | 2010-07-29 00:00:00 | 2010-11-30 00:00:00 | 2010-11-16 00:00:00 | 2010-07-29 00:00:00 | NO | YES | NO | YES | 2011-11-16 00:00:00 | 2012-02-16 00:00:00 | YES | 2012-02-16 00:00:00 | 2012-01-01 00:00:00 | NA | 2012-05-12 00:00:00 | NA | 2010-11-30 00:00:00 | 2010-11-30 00:00:00 | 2010-11-30 00:00:00 | 2010-11-30 00:00:00
WMJB | Name 4 | 2011-07-20 00:00:00 | 2011-07-20 00:00:00 | 2011-07-20 00:00:00 | 2011-06-29 00:00:00 | 2011-01-03 00:00:00 | 2010-09-27 00:00:00 | 2011-07-20 00:00:00 | 2010-09-27 00:00:00 | 2011-07-19 00:00:00 | 2011-07-20 00:00:00 | 2010-09-27 00:00:00 | YES | YES | YES | YES | 2012-01-26 00:00:00 | 2012-04-03 00:00:00 | YES | 2012-04-03 00:00:00 | 2011-12-28 00:00:00 | NA | 2012-01-04 00:00:00 | NA | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00
MXWR | Name 5 | 2011-01-07 00:00:00 | 2011-01-07 00:00:00 | 2011-01-07 00:00:00 | 2011-07-22 00:00:00 | 2011-06-02 00:00:00 | 2011-02-24 00:00:00 | 2011-01-07 00:00:00 | 2011-02-24 00:00:00 | 2011-04-05 00:00:00 | 2011-02-18 00:00:00 | 2011-02-24 00:00:00 | YES | YES | YES | YES | 2012-04-17 00:00:00 | NA | NA | NA | 2012-03-08 00:00:00 | NA | 2012-07-18 00:00:00 | 2012-10-21 00:00:00 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00
WMJA | Name 6 | 2010-11-09 00:00:00 | 2010-11-09 00:00:00 | 2011-08-08 00:00:00 | 2011-07-01 00:00:00 | 2010-11-16 00:00:00 | 2010-08-03 00:00:00 | 2011-08-08 00:00:00 | 2010-08-03 00:00:00 | 2010-08-15 00:00:00 | 2011-01-04 00:00:00 | 2010-07-29 00:00:00 | YES | YES | NO | YES | 2011-12-17 00:00:00 | 2012-04-04 00:00:00 | YES | 2012-04-04 00:00:00 | 2011-11-18 00:00:00 | NA | 2011-08-15 00:00:00 | NA | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00 | 2010-09-30 00:00:00
WMJA | Name 7 | 2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 2011-08-12 00:00:00 | 2011-06-10 00:00:00 | 2011-06-02 00:00:00 | 2011-02-02 00:00:00 | 2011-08-12 00:00:00 | 2011-07-28 00:00:00 | 2011-07-22 00:00:00 | 2011-02-02 00:00:00 | 2011-02-02 00:00:00 | NO | YES | YES | YES | 2011-10-20 00:00:00 | 2011-12-09 00:00:00 | YES | 2011-12-09 00:00:00 | 2011-10-20 00:00:00 | NA | 2012-01-21 00:00:00 | NA | 2011-07-18 00:00:00 | 2011-07-18 00:00:00 | 2011-07-18 00:00:00 | 2011-07-18 00:00:00
WMJA | Name 8 | 2011-06-01 00:00:00 | 2011-06-07 00:00:00 | 2011-06-07 00:00:00 | 2011-06-10 00:00:00 | 2011-06-02 00:00:00 | 2011-02-18 00:00:00 | 2011-06-07 00:00:00 | 2011-06-13 00:00:00 | 2011-04-05 00:00:00 | 2011-02-18 00:00:00 | 2011-02-18 00:00:00 | YES | YES | YES | YES | 2011-10-21 00:00:00 | 2012-03-13 00:00:00 | YES | 2012-03-13 00:00:00 | 2012-06-06 00:00:00 | NA | 2011-07-31 00:00:00 | NA | 2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00 | 2011-04-05 00:00:00