Spreadsheet: 770417d1646057676-transposing-multiple-rows-in-columns-for-each-unique-name-in-column-a-test-3_unpivot
Sheet: Sheet1

Name | Project | Time | Duration | 15-Nov | 16-Nov | 17-Nov | 18-Nov | 19-Nov | 20-Nov | 21-Nov |  |  | On the left is current, on the right is what I want it to be. |  |  |  | Date | Name | Probability
[NAME] | Project 1 | 1600 | 40 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  | 15-Nov | [NAME] | 100
[NAME] | Project 2 | 1500 | 60 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  |  |  |  |  |  | 16-Nov | [NAME] | 100
Mark | Project 2 | 1600 | 30 | 80 | 80 | 80 | 80 | 80 | 80 | 80 |  |  |  |  |  |  | 17-Nov | [NAME] | 100
[NAME] | Project 3 | 1600 | 60 | 60 | 60 | 60 | 60 | 60 | 60 | 60 |  |  |  |  |  |  | 18-Nov | [NAME] | 100
Emily | Project 4 | 1200 | 30 | 60 | 60 | 60 | 60 | 60 | 60 | 60 |  |  |  |  |  |  | 19-Nov | [NAME] | 100
[NAME] | Project 5 | 700 | 50 | 60 | 60 | 60 | 60 | 60 | 60 | 60 |  |  |  |  |  |  | 20-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-Nov | [NAME] | 100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15-Nov | Mark | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16-Nov | Mark | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17-Nov | Mark | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18-Nov | Mark | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19-Nov | Mark | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-Nov | Mark | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-Nov | Mark | 80
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15-Nov | Emily | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16-Nov | Emily | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17-Nov | Emily | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18-Nov | Emily | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19-Nov | Emily | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-Nov | Emily | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-Nov | Emily | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20-Nov | [NAME] | 60
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21-Nov | [NAME] | 60