Spreadsheet: 31304d1227115409-data-in-columns-to-rows-not-transpose-copy-of-whatiwanttodo
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | My Opinion
THIS IS MY SOURCE DATA I NEED TO CLEAN UP |  |  |  |  |  |  |  |  | THIS IS MY SOURCE DATA I NEED TO CLEAN UP
Jan 1 - Dec 31 2009 | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
Jan1 -Jan13 | 49 | 50 | 54 | 54 | 40 | 41 | 36 |  | 2009-01-07 00:00:00 | 2009-01-13 00:00:00 | 49 | 50 | 54 | 54 | 40 | 41 | 36
Jan 14 - Jan 20 | 49 | 61 | 56 | 47 | 34 | 42 | 42 |  | 2009-01-14 00:00:00 | 2009-01-20 00:00:00 | 49 | 61 | 56 | 47 | 34 | 42 | 42
Jan 21 - Jan 27 | 40 | 60 | 56 | 58 | 71 | 64 | 31 |  | 2009-01-21 00:00:00 | 2009-01-27 00:00:00 | 40 | 60 | 56 | 58 | 71 | 64 | 31
Jan 28 - Feb 3 | 39 | 42 | 51 | 73 | 83 | 82 | 45 |  | 2009-01-28 00:00:00 | 2009-02-03 00:00:00 | 39 | 42 | 51 | 73 | 83 | 82 | 45
Feb 4 - Feb 10 | 62 | 97 | 78 | 70 | 55 | 70 | 51 |  | 2009-02-04 00:00:00 | 2009-02-10 00:00:00 | 62 | 97 | 78 | 70 | 55 | 70 | 51
Feb 11 - Feb 17 | 45 | 62 | 79 | 72 | 82 | 79 | 50 |  | 2009-02-11 00:00:00 | 2009-02-17 00:00:00 | 45 | 62 | 79 | 72 | 82 | 79 | 50
Feb 18 - Feb 24 | 59 | 68 | 57 | 63 | 71 | 64 | 42 |  | 2009-02-18 00:00:00 | 2009-02-24 00:00:00 | 59 | 68 | 57 | 63 | 71 | 64 | 42
Feb 25 - Mar 2 | 44 | 52 | 64 | 70 | 73 | 64 | 50 |  | 2009-02-25 00:00:00 | 2009-03-02 00:00:00 | 44 | 52 | 64 | 70 | 73 | 64 | 50
[NAME] 9 | 57 | 82 | 95 | 87 | 99 | 89 | 71 |  | 2009-03-03 00:00:00 | 2009-03-09 00:00:00 | 57 | 82 | 95 | 87 | 99 | 89 | 71
[NAME] 16 | 83 | 91 | 103 | 104 | 102 | 109 | 100 |  | 2009-03-10 00:00:00 | 2009-03-16 00:00:00 | 83 | 91 | 103 | 104 | 102 | 109 | 100
[NAME] 23 | 104 | 71 | 79 | 72 | 92 | 89 | 78 |  | 2009-03-17 00:00:00 | 2009-03-23 00:00:00 | 104 | 71 | 79 | 72 | 92 | 89 | 78
THIS IS HOW I WOULD WANT IT TO BE |  |  |  |  |  |  |  |  | THIS IS HOW I WOULD WANT IT TO BE
2009-01-07 00:00:00 | 49 |  |  |  |  |  |  |  |  | 2009-01-07 00:00:00 | 49
2009-01-08 00:00:00 | 50 |  |  |  |  |  |  |  |  | 2009-01-08 00:00:00 | 50
2009-01-09 00:00:00 | 54 |  |  |  |  |  |  |  |  | 2009-01-09 00:00:00 | 54
2009-01-10 00:00:00 | 54 |  |  |  |  |  |  |  |  | 2009-01-10 00:00:00 | 54
2009-01-11 00:00:00 | 40 |  |  |  |  |  |  |  |  | 2009-01-11 00:00:00 | 40
2009-01-12 00:00:00 | 41 |  |  | I do not need to convert the text format dates above into Excel date format, I can do this manually. |  |  |  |  |  | 2009-01-12 00:00:00 | 41 |  |  | k21                                K21+7
2009-01-13 00:00:00 | 36 |  |  |  |  |  |  |  |  | 2009-01-13 00:00:00 | 36
2009-01-14 00:00:00 | 49 |  |  |  |  |  |  |  |  | 2009-01-14 00:00:00 | 49
2009-01-15 00:00:00 | 61 |  |  |  |  |  |  |  |  | 2009-01-15 00:00:00 | 61
2009-01-16 00:00:00 | 56 |  |  |  |  |  |  |  |  | 2009-01-16 00:00:00 | 56
2009-01-17 00:00:00 | 47 |  |  |  |  |  |  |  |  | 2009-01-17 00:00:00 | 47
2009-01-18 00:00:00 | 34 |  |  |  |  |  |  |  |  | 2009-01-18 00:00:00 | 34
2009-01-19 00:00:00 | 42 |  |  |  |  |  |  |  |  | 2009-01-19 00:00:00 | 42
2009-01-20 00:00:00 | 42 |  |  |  |  |  |  |  |  | 2009-01-20 00:00:00 | 42
2009-01-21 00:00:00 | 40 |  |  |  |  |  |  |  |  | 2009-01-21 00:00:00 | 40
2009-01-22 00:00:00 | 60 |  |  |  |  |  |  |  |  | 2009-01-22 00:00:00 | 60
2009-01-23 00:00:00 | 56 |  |  |  |  |  |  |  |  | 2009-01-23 00:00:00 | 56
2009-01-24 00:00:00 | 58 |  |  |  |  |  |  |  |  | 2009-01-24 00:00:00 | 58
2009-01-25 00:00:00 | 71 |  |  |  |  |  |  |  |  | 2009-01-25 00:00:00 | 71
2009-01-26 00:00:00 | 64 |  |  |  |  |  |  |  |  | 2009-01-26 00:00:00 | 64
2009-01-27 00:00:00 | 31 |  |  |  |  |  |  |  |  | 2009-01-27 00:00:00 | 31
2009-01-28 00:00:00 | 39 |  |  |  |  |  |  |  |  | 2009-01-28 00:00:00 | 39
2009-01-29 00:00:00 | 42 |  |  |  |  |  |  |  |  | 2009-01-29 00:00:00 | 42
2009-01-30 00:00:00 | 51 |  |  |  |  |  |  |  |  | 2009-01-30 00:00:00 | 51
2009-01-31 00:00:00 | 73 |  |  |  |  |  |  |  |  | 2009-01-31 00:00:00 | 73
2009-02-01 00:00:00 | 83 |  |  |  |  |  |  |  |  | 2009-02-01 00:00:00 | 83
2009-02-02 00:00:00 | 82 |  |  |  |  |  |  |  |  | 2009-02-02 00:00:00 | 82
2009-02-03 00:00:00 | 45 |  |  |  |  |  |  |  |  | 2009-02-03 00:00:00 | 45