Spreadsheet: 716647d1612296647-copy-a-line-of-data-to-a-new-worksheet-every-time-value-appears-without-blank-rows-demo-2
Sheet: Sheet 1

 |  |  | 2020-04-01 00:00:00 |  |  |  | 2020-05-01 00:00:00 |  |  |  | 2020-06-01 00:00:00 |  |  |  |  | 2020-07-01 00:00:00 |  |  |  | 2020-08-01 00:00:00 |  |  |  | 2020-09-01 00:00:00 |  |  |  |  | 2020-10-01 00:00:00 |  |  |  | 2020-11-01 00:00:00 |  |  |  | 2020-12-01 00:00:00 |  |  |  |  | 2021-01-01 00:00:00 |  |  |  | 2021-02-01 00:00:00 |  |  |  | 2021-03-01 00:00:00
 | Project | Resource allocation | 2020-04-06 00:00:00 | 2020-04-13 00:00:00 | 2020-04-20 00:00:00 | 2020-04-27 00:00:00 | 2020-05-04 00:00:00 | 2020-05-11 00:00:00 | 2020-05-18 00:00:00 | 2020-05-25 00:00:00 | 2020-06-01 00:00:00 | 2020-06-08 00:00:00 | 2020-06-15 00:00:00 | 2020-06-22 00:00:00 | 2020-06-29 00:00:00 | 2020-07-06 00:00:00 | 2020-07-13 00:00:00 | 2020-07-20 00:00:00 | 2020-07-27 00:00:00 | 2020-08-03 00:00:00 | 2020-08-10 00:00:00 | 2020-08-17 00:00:00 | 2020-08-24 00:00:00 | 2020-08-31 00:00:00 | 2020-09-07 00:00:00 | 2020-09-14 00:00:00 | 2020-09-21 00:00:00 | 2020-09-28 00:00:00 | 2020-10-05 00:00:00 | 2020-10-12 00:00:00 | 2020-10-19 00:00:00 | 2020-10-26 00:00:00 | 2020-11-02 00:00:00 | 2020-11-09 00:00:00 | 2020-11-16 00:00:00 | 2020-11-23 00:00:00 | 2020-11-30 00:00:00 | 2020-12-07 00:00:00 | 2020-12-14 00:00:00 | 2020-12-21 00:00:00 | 2020-12-28 00:00:00 | 2021-01-04 00:00:00 | 2021-01-11 00:00:00 | 2021-01-18 00:00:00 | 2021-01-25 00:00:00 | 2021-02-01 00:00:00 | 2021-02-08 00:00:00 | 2021-02-15 00:00:00 | 2021-02-22 00:00:00 | 2021-03-01 00:00:00 | 2021-03-08 00:00:00 | 2021-03-15 00:00:00 | 2021-03-22 00:00:00 | 2021-03-29 00:00:00
 | Project A
 | Programme Manager | [NAME] | 16 | 16 | 16 | 16 | 15 | 15 | 15.5 | 15.5 | 10.5 | 10.5 | 8.5 | 8.5 | 8,5 | 2.5 | 2.5 | 2.5 | 2.5 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | Project Manager
 | Business Analyst | Ellie | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 | Project Officer
 | Project B
 | Programme Manager |  | 0.5 | 0.5 | 1 | 1 | 1 | 1 | 1 | 1
 | Project Manager | Ranbir | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Business Analyst
 | Project Officer
 | Project C
 | Programme Manager |  | 8 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 8 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Project Manager | [NAME] | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 | Business Analyst
 | Project Officer
 | Project D
 | Programme Manager |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | Project Manager | Jonny | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15 | 15
 | Business Analyst | Ellie | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 | Project Officer
 | Project E
 | Programme Manager | [NAME] |  |  |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 3.5 | 7.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2.5 | 2 | 2 | 1 | 1
 | Project Manager | [NAME]
 | Business Analyst
 | Project Officer