Spreadsheet: 873609d1720108139-powerquery-help-required-capture-assignment-from-and-to-help-required
Sheet: Sheet1

Number | mi_value | Start | End |  | Number | mi_value | Start | End | From | To
INC1 | [NAME] | 2021-07-06 11:16:24 | 2021-07-06 11:50:57 |  | INC1 | [NAME] | 2021-07-06 11:16:24 | 2021-07-06 11:50:57 | [NAME] | [NAME]
INC1 | Assignment_2 | 2021-07-06 11:50:57 | 2021-07-06 14:51:46 |  | INC1 | Assignment_2 | 2021-07-06 11:50:57 | 2021-07-06 14:51:46 | [NAME] | Assignment_2
INC1 | Assignment_3 | 2021-07-06 14:51:46 | 2021-07-07 16:49:29 |  | INC1 | Assignment_3 | 2021-07-06 14:51:46 | 2021-07-07 16:49:29 | Assignment_2 | Assignment_3
INC1 | [NAME] | 2021-07-07 16:49:29 | 2021-07-07 16:59:39 |  | INC1 | [NAME] | 2021-07-07 16:49:29 | 2021-07-07 16:59:39 | Assignment_3 | [NAME]
INC1 | Assignment_2 | 2021-07-07 16:59:39 | 2021-07-07 17:01:53 |  | INC1 | Assignment_2 | 2021-07-07 16:59:39 | 2021-07-07 17:01:53 | [NAME] | Assignment_2
INC1 | Assignment_5 | 2021-07-07 17:01:53 | 2021-07-12 14:21:37 |  | INC1 | Assignment_5 | 2021-07-07 17:01:53 | 2021-07-12 14:21:37 | Assignment_2 | Assignment_5
INC1 | Assignment_3 | 2021-07-12 14:21:37 | 2021-07-21 08:14:50 |  | INC1 | Assignment_3 | 2021-07-12 14:21:37 | 2021-07-21 08:14:50 | Assignment_5 | Assignment_3
INC1 | [NAME] | 2021-07-21 08:14:50 | 2021-07-21 10:04:07 |  | INC1 | [NAME] | 2021-07-21 08:14:50 | 2021-07-21 10:04:07 | Assignment_3 | [NAME]
INC1 | Assignment_2 | 2021-07-21 10:04:07 | 2021-07-21 10:24:10 |  | INC1 | Assignment_2 | 2021-07-21 10:04:07 | 2021-07-21 10:24:10 | [NAME] | Assignment_2
INC1 | Assignment_5 | 2021-07-21 10:24:10 | 2021-07-21 11:00:05 |  | INC1 | Assignment_5 | 2021-07-21 10:24:10 | 2021-07-21 11:00:05 | Assignment_2 | Assignment_5
INC1 | Assignment_3 | 2021-07-21 11:00:05 | 2021-07-21 17:00:16 |  | INC1 | Assignment_3 | 2021-07-21 11:00:05 | 2021-07-21 17:00:16 | Assignment_5 | Assignment_3
INC1 | [NAME] | 2021-07-21 17:00:16 | 2021-07-21 18:03:50 |  | INC1 | [NAME] | 2021-07-21 17:00:16 | 2021-07-21 18:03:50 | Assignment_3 | [NAME]
INC1 | Assignment_2 | 2021-07-21 18:03:50 | 2021-07-21 18:04:25 |  | INC1 | Assignment_2 | 2021-07-21 18:03:50 | 2021-07-21 18:04:25 | [NAME] | Assignment_2
INC1 | Assignment_5 | 2021-07-21 18:04:25 | 2021-07-22 15:58:25 |  | INC1 | Assignment_5 | 2021-07-21 18:04:25 | 2021-07-22 15:58:25 | Assignment_2 | Assignment_5
INC1 | Assignment_3 | 2021-07-22 15:58:25 | 2021-07-23 02:10:29 |  | INC1 | Assignment_3 | 2021-07-22 15:58:25 | 2021-07-23 02:10:29 | Assignment_5 | Assignment_3
INC1 | [NAME] | 2021-07-23 02:10:29 | 2021-07-23 07:59:49 |  | INC1 | [NAME] | 2021-07-23 02:10:29 | 2021-07-23 07:59:49 | Assignment_3 | [NAME]
INC1 | Assignment_2 | 2021-07-23 07:59:49 | 2021-07-23 10:39:43 |  | INC1 | Assignment_2 | 2021-07-23 07:59:49 | 2021-07-23 10:39:43 | [NAME] | Assignment_2
INC1 | Assignment_5 | 2021-07-23 10:39:43 | 2021-07-23 11:31:33 |  | INC1 | Assignment_5 | 2021-07-23 10:39:43 | 2021-07-23 11:31:33 | Assignment_2 | Assignment_5
INC1 | Assignment_3 | 2021-07-23 11:31:33 | 2021-07-26 14:17:16 |  | INC1 | Assignment_3 | 2021-07-23 11:31:33 | 2021-07-26 14:17:16 | Assignment_5 | Assignment_3
INC1 | [NAME] | 2021-07-26 14:17:16 | 2021-07-26 14:38:30 |  | INC1 | [NAME] | 2021-07-26 14:17:16 | 2021-07-26 14:38:30 | Assignment_3 | [NAME]
INC1 | Assignment_2 | 2021-07-26 14:38:30 | 2021-07-26 14:44:15 |  | INC1 | Assignment_2 | 2021-07-26 14:38:30 | 2021-07-26 14:44:15 | [NAME] | Assignment_2
INC1 | [NAME] | 2021-07-26 14:44:15 | 2021-07-26 15:30:16 |  | INC1 | [NAME] | 2021-07-26 14:44:15 | 2021-07-26 15:30:16 | Assignment_2 | [NAME]
INC1 | Assignment_2 | 2021-07-26 15:30:16 | 2021-07-26 15:32:17 |  | INC1 | Assignment_2 | 2021-07-26 15:30:16 | 2021-07-26 15:32:17 | [NAME] | Assignment_2
INC1 | Assignment_6 | 2021-07-26 15:32:17 | 2021-07-26 16:02:06 |  | INC1 | Assignment_6 | 2021-07-26 15:32:17 | 2021-07-26 16:02:06 | Assignment_2 | Assignment_6
INC1 | Assignment_3 | 2021-07-26 16:02:06 | 2021-07-29 10:54:56 |  | INC1 | Assignment_3 | 2021-07-26 16:02:06 | 2021-07-29 10:54:56 | Assignment_6 | Assignment_3
INC1 | [NAME] | 2021-07-29 10:54:56 | 2021-07-29 11:38:40 |  | INC1 | [NAME] | 2021-07-29 10:54:56 | 2021-07-29 11:38:40 | Assignment_3 | [NAME]
INC1 | Assignment_2 | 2021-07-29 11:38:40 | 2021-07-29 11:42:22 |  | INC1 | Assignment_2 | 2021-07-29 11:38:40 | 2021-07-29 11:42:22 | [NAME] | Assignment_2
INC1 | Assignment_3 | 2021-07-29 11:42:22 | 2021-07-29 13:30:07 |  | INC1 | Assignment_3 | 2021-07-29 11:42:22 | 2021-07-29 13:30:07 | Assignment_2 | Assignment_3
INC1 | [NAME] | 2021-07-29 13:30:07 | 2021-07-29 14:15:29 |  | INC1 | [NAME] | 2021-07-29 13:30:07 | 2021-07-29 14:15:29 | Assignment_3 | [NAME]
INC1 | Assignment_2 | 2021-07-29 14:15:29 | 2021-08-03 11:25:56 |  | INC1 | Assignment_2 | 2021-07-29 14:15:29 | 2021-08-03 11:25:56 | [NAME] | Assignment_2
INC1 | Assignment_5 | 2021-08-03 11:25:56 | 2023-01-01 00:00:00 |  | INC1 | Assignment_5 | 2021-08-03 11:25:56 | 2023-01-01 00:00:00 | Assignment_2 | Assignment_5
INC2 | Assignment_7 | 2022-02-01 12:48:53 | 2022-02-01 12:50:34 |  | INC2 | Assignment_7 | 2022-02-01 12:48:53 | 2022-02-01 12:50:34 | Assignment_7 | Assignment_7
INC2 | Assignment_8 | 2022-02-01 12:50:34 | 2023-01-01 00:00:04 |  | INC2 | Assignment_8 | 2022-02-01 12:50:34 | 2023-01-01 00:00:04 | Assignment_7 | Assignment_8
INC3 | Assignment_7 | 2022-03-23 10:17:07 | 2022-03-23 10:25:02 |  | INC3 | Assignment_7 | 2022-03-23 10:17:07 | 2022-03-23 10:25:02 | Assignment_7 | Assignment_7
INC3 | Assignment_8 | 2022-03-23 10:25:02 | 2023-01-01 00:00:05 |  | INC3 | Assignment_8 | 2022-03-23 10:25:02 | 2023-01-01 00:00:05 | Assignment_7 | Assignment_8
INC4 | Assignment_9 | 2022-04-08 13:22:01 | 2022-04-08 13:31:44 |  | INC4 | Assignment_9 | 2022-04-08 13:22:01 | 2022-04-08 13:31:44 | Assignment_9 | Assignment_9
INC4 | Assignment_10 | 2022-04-08 13:31:44 | 2022-04-11 08:07:13 |  | INC4 | Assignment_10 | 2022-04-08 13:31:44 | 2022-04-11 08:07:13 | Assignment_9 | Assignment_10
INC4 | [NAME] | 2022-04-11 08:07:13 | 2022-04-11 08:44:08 |  | INC4 | [NAME] | 2022-04-11 08:07:13 | 2022-04-11 08:44:08 | Assignment_10 | [NAME]
INC4 | Assignment_11 | 2022-04-11 08:44:08 | 2022-04-11 08:44:19 |  | INC4 | Assignment_11 | 2022-04-11 08:44:08 | 2022-04-11 08:44:19 | [NAME] | Assignment_11
INC4 | Assignment_5 | 2022-04-11 08:44:19 | 2023-01-01 00:00:06 |  | INC4 | Assignment_5 | 2022-04-11 08:44:19 | 2023-01-01 00:00:06 | Assignment_11 | Assignment_5
INC5 | Assignment_7 | 2022-04-22 12:44:56 | 2022-04-22 13:18:12 |  | INC5 | Assignment_7 | 2022-04-22 12:44:56 | 2022-04-22 13:18:12 | Assignment_7 | Assignment_7
INC5 | Assignment_8 | 2022-04-22 13:18:12 | 2023-01-01 00:00:08 |  | INC5 | Assignment_8 | 2022-04-22 13:18:12 | 2023-01-01 00:00:08 | Assignment_7 | Assignment_8
INC6 | Assignment_9 | 2022-05-12 12:05:08 | 2022-05-17 14:15:57 |  | INC6 | Assignment_9 | 2022-05-12 12:05:08 | 2022-05-17 14:15:57 | Assignment_9 | Assignment_9
INC6 | Assignment_12 | 2022-05-17 14:15:57 | 2022-05-17 14:19:48 |  | INC6 | Assignment_12 | 2022-05-17 14:15:57 | 2022-05-17 14:19:48 | Assignment_9 | Assignment_12
INC6 | [NAME] | 2022-05-17 14:19:48 | 2022-05-17 14:45:43 |  | INC6 | [NAME] | 2022-05-17 14:19:48 | 2022-05-17 14:45:43 | Assignment_12 | [NAME]
INC6 | Assignment_13 | 2022-05-17 14:45:43 | 2022-05-18 12:58:41 |  | INC6 | Assignment_13 | 2022-05-17 14:45:43 | 2022-05-18 12:58:41 | [NAME] | Assignment_13
INC6 | [NAME] | 2022-05-18 12:58:41 | 2022-05-18 13:49:15 |  | INC6 | [NAME] | 2022-05-18 12:58:41 | 2022-05-18 13:49:15 | Assignment_13 | [NAME]
INC6 | Assignment_10 | 2022-05-18 13:49:15 | 2022-05-18 18:10:14 |  | INC6 | Assignment_10 | 2022-05-18 13:49:15 | 2022-05-18 18:10:14 | [NAME] | Assignment_10
INC6 | [NAME] | 2022-05-18 18:10:14 | 2022-05-18 20:27:32 |  | INC6 | [NAME] | 2022-05-18 18:10:14 | 2022-05-18 20:27:32 | Assignment_10 | [NAME]
INC6 | Assignment_9 | 2022-05-18 20:27:32 | 2022-05-25 14:00:09 |  | INC6 | Assignment_9 | 2022-05-18 20:27:32 | 2022-05-25 14:00:09 | [NAME] | Assignment_9
INC6 | Assignment_14 | 2022-05-25 14:00:09 | 2022-05-30 10:11:43 |  | INC6 | Assignment_14 | 2022-05-25 14:00:09 | 2022-05-30 10:11:43 | Assignment_9 | Assignment_14
INC6 | Assignment_15 | 2022-05-30 10:11:43 | 2022-05-30 10:13:00 |  | INC6 | Assignment_15 | 2022-05-30 10:11:43 | 2022-05-30 10:13:00 | Assignment_14 | Assignment_15
INC6 | Assignment_16 | 2022-05-30 10:13:00 | 2022-05-30 15:09:00 |  | INC6 | Assignment_16 | 2022-05-30 10:13:00 | 2022-05-30 15:09:00 | Assignment_15 | Assignment_16
INC6 | Assignment_17 | 2022-05-30 15:09:00 | 2022-05-30 15:20:05 |  | INC6 | Assignment_17 | 2022-05-30 15:09:00 | 2022-05-30 15:20:05 | Assignment_16 | Assignment_17
INC6 | Assignment_2 | 2022-05-30 15:20:05 | 2022-05-30 16:33:00 |  | INC6 | Assignment_2 | 2022-05-30 15:20:05 | 2022-05-30 16:33:00 | Assignment_17 | Assignment_2
INC6 | Assignment_10 | 2022-05-30 16:33:00 | 2022-05-30 17:02:40 |  | INC6 | Assignment_10 | 2022-05-30 16:33:00 | 2022-05-30 17:02:40 | Assignment_2 | Assignment_10
INC6 | [NAME] | 2022-05-30 17:02:40 | 2022-05-30 17:25:08 |  | INC6 | [NAME] | 2022-05-30 17:02:40 | 2022-05-30 17:25:08 | Assignment_10 | [NAME]
INC6 | Assignment_11 | 2022-05-30 17:25:08 | 2022-05-30 20:25:02 |  | INC6 | Assignment_11 | 2022-05-30 17:25:08 | 2022-05-30 20:25:02 | [NAME] | Assignment_11
INC6 | Assignment_5 | 2022-05-30 20:25:02 | 2023-01-01 00:00:09 |  | INC6 | Assignment_5 | 2022-05-30 20:25:02 | 2023-01-01 00:00:09 | Assignment_11 | Assignment_5
INC7 | Assignment_7 | 2022-05-19 12:21:56 | 2022-05-23 16:43:43 |  | INC7 | Assignment_7 | 2022-05-19 12:21:56 | 2022-05-23 16:43:43 | Assignment_7 | Assignment_7
INC7 | Assignment_18 | 2022-05-23 16:43:43 | 2022-06-06 07:57:44 |  | INC7 | Assignment_18 | 2022-05-23 16:43:43 | 2022-06-06 07:57:44 | Assignment_7 | Assignment_18
INC7 | Assignment_7 | 2022-06-06 07:57:44 | 2022-06-06 15:49:45 |  | INC7 | Assignment_7 | 2022-06-06 07:57:44 | 2022-06-06 15:49:45 | Assignment_18 | Assignment_7
INC7 | Assignment_19 | 2022-06-06 15:49:45 | 2023-01-01 00:00:19 |  | INC7 | Assignment_19 | 2022-06-06 15:49:45 | 2023-01-01 00:00:19 | Assignment_7 | Assignment_19
INC8 | Assignment_20 | 2022-05-23 14:24:48 | 2023-01-01 00:00:21 |  | INC8 | Assignment_20 | 2022-05-23 14:24:48 | 2023-01-01 00:00:21 | Assignment_20 | Assignment_20
INC9 | Assignment_9 | 2022-05-30 13:23:26 | 2022-05-30 13:29:51 |  | INC9 | Assignment_9 | 2022-05-30 13:23:26 | 2022-05-30 13:29:51 | Assignment_9 | Assignment_9
INC9 | Assignment_5 | 2022-05-30 13:29:51 | 2023-01-01 00:00:21 |  | INC9 | Assignment_5 | 2022-05-30 13:29:51 | 2023-01-01 00:00:21 | Assignment_9 | Assignment_5