Spreadsheet: 758089d1638636022-automate-merge-weekly-time-data-into-consolidated-monthly-variable-data-structure-timeexamplenov2021
Sheet: Example, month merge

Project | 01.Lap.21 | 02.Lap.21 | 03.Lap.21 | 04.Lap.21 | 05.Lap.21 | 06.Lap.21 | 07.Lap.21 | 08.Lap.21 | 09.Lap.21 | 10.Lap.21 | 11.Lap.21 | 12.Lap.21 | 13.Lap.21 | 14.Lap.21 | 15.Lap.21 | 16.Lap.21 | 17.Lap.21 | 18.Lap.21 | 19.Lap.21 | 20.Lap.21 | 21.Lap.21 | 22.Lap.21 | 23.Lap.21 | 24.Lap.21 | 25.Lap.21 | 26.Lap.21 | 27.Lap.21 | 28.Lap.21 | 29.Lap.21 | 30.Lap.21
XCo.CapRaise | 00:00:00 | 00:24:25 | 00:00:00 | 01:07:39 | 00:00:00 | 00:00:00 | 02:51:39
XCo.CapRaise |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 | 03:20:00 | 00:41:00 | 00:00:00 | 00:00:00
XCo.CapRaise |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:30:00 | 00:07:28 | 00:11:08 | 01:11:32 | 00:31:10 | 00:00:00 | 00:00:00
XCo.CapRaise |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:40:34 | 00:00:00 | 00:55:06 | 00:00:00 | 02:23:03 | 00:00:00 | 00:00:00
XCo.CapRaise |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:19:12 | 00:00:00
XCo.[NAME].Bids |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 01:16:32 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
XCo.[NAME].Bids |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:48:37 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
XCo.[NAME].Bids |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:17:47 | 00:00:00
XCo.[NAME].Maroc |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 01:13:55 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
XCo.[NAME].Maroc |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:16:14 | 00:00:00 | 00:00:00
XCo.[NAME].Senegal | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:16:20 | 00:00:00 | 00:00:00
XCo.[NAME].Senegal |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:20:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
XCo.[NAME].Senegal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:40:40 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
XCo.Legal |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 | 02:11:25 | 03:02:32 | 00:00:00 | 00:00:00
XCo.Legal |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 01:30:00 | 00:41:31 | 00:00:00 | 02:37:31 | 00:00:00 | 01:27:34
XCo.Legal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:13:27 | 00:10:55 | 00:14:25 | 00:41:45 | 02:20:08 | 03:03:51 | 02:51:44
XCo.[NAME].[NAME] | 00:00:00 | 00:00:00 | 00:30:57 | 00:44:27 | 00:00:00 | 00:00:00 | 00:00:00
XCo.[NAME].[NAME] |  |  |  |  |  |  |  | 00:10:34 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
XCo.[NAME].[NAME] |  |  |  |  |  |  |  | 00:00:00 | 00:00:00 | 00:00:00 | 01:00:00 | 00:00:00 | 00:00:00 | 00:00:00
XCo.[NAME].[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:57:50 | 00:00:00 | 00:58:30 | 01:48:46 | 00:00:00 | 00:00:00
XCo.[NAME].[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:48:02 | 00:00:00 | 00:00:00 | 00:00:00 | 01:38:38 | 00:00:00 | 00:00:00
XCo.[NAME].[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:57:16 | 00:00:00
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:00:00
YCo.Admin.ComputerIssuesSolving | 04:56:00 | 00:10:32 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 01:01:49
YCo.Admin.ComputerIssuesSolving |  |  |  |  |  |  |  | 00:24:30 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
YCo.Admin.ComputerIssuesSolving |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:00:00 | 00:11:39 | 00:00:00 | 00:25:15 | 00:00:00 | 00:00:00 | 00:00:00
YCo.Admin.Fin | 00:00:00 | 01:18:50 | 00:00:00 | 00:00:00 | 00:00:00 | 00:55:01 | 01:58:18
YCo.Admin.Fin |  |  |  |  |  |  |  | 00:30:49 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
YCo.Admin.Fin |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:10:00 | 00:00:00 | 00:14:47 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00
YCo.Admin.Fin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 01:38:04 | 00:00:00 | 00:00:00 | 00:00:00 | 00:16:11 | 00:00:00 | 00:00:00
YCo.Admin.Fin |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 00:21:04 | 00:00:00