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

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