Spreadsheet: 806826d1669623840-extracting-and-reformating-data-from-pivot-table-efpivottimefullset
Sheet: Sheet1

time | path | to a | To B |  | TO A | TO B
04:00:00 | To B
04:30:00 | To B |  |  |  | 05:15:00 | 04:30:00
04:45:00 | To A |  |  |  | 05:45:00 | 05:00:00
05:00:00 | To B |  |  |  | 06:14:00 | 05:30:00
05:15:00 | To A |  |  |  | 06:34:00 | 06:00:00
05:30:00 | To B |  |  |  | 06:54:00 | 06:20:00
05:45:00 | To A |  |  |  | 07:14:00 | 06:40:00
06:00:00 | To B |  |  |  | 07:34:00 | 07:00:00
06:14:00 | To A |  |  |  | 07:54:00 | 07:20:00
06:20:00 | To B |  |  |  | 08:14:00 | 07:40:00
06:34:00 | To A |  |  |  | 08:34:00 | 08:00:00
06:40:00 | To B |  |  |  | 08:54:00 | 08:20:00
06:54:00 | To A |  |  |  | 09:16:00 | 08:40:00
07:00:00 | To B |  |  |  | 09:40:00 | 09:00:00
07:14:00 | To A |  |  |  | 10:04:00 | 09:24:00
07:20:00 | To B |  |  |  | 10:30:00 | 09:48:00
07:34:00 | To A |  |  |  | 10:54:00 | 10:12:00
07:40:00 | To B |  |  |  | 11:14:00 | 10:36:00
07:54:00 | To A |  |  |  | 11:34:00 | 10:53:00
08:00:00 | To B |  |  |  | 11:54:00 | 11:13:00
08:14:00 | To A |  |  |  | 12:14:00 | 11:33:00
08:20:00 | To B |  |  |  | 12:34:00 | 11:53:00
08:34:00 | To A |  |  |  | 12:54:00 | 12:13:00
08:40:00 | To B |  |  |  | 13:14:00 | 12:33:00
08:54:00 | To A |  |  |  | 13:34:00 | 12:53:00
09:00:00 | To B |  |  |  | 13:54:00 | 13:13:00
09:16:00 | To A |  |  |  | 14:12:00 | 13:33:00
09:24:00 | To B |  |  |  | 14:32:00 | 13:53:00
09:40:00 | To A |  |  |  | 14:52:00 | 14:11:00
09:48:00 | To B |  |  |  | 15:12:00 | 14:31:00
10:04:00 | To A |  |  |  | 15:32:00 | 14:51:00
10:12:00 | To B |  |  |  | 15:52:00 | 15:11:00
10:30:00 | To A |  |  |  | 16:12:00 | 15:31:00
10:36:00 | To B |  |  |  | 16:32:00 | 15:51:00
10:53:00 | To B |  |  |  | 16:52:00 | 16:11:00
10:54:00 | To A |  |  |  | 17:12:00 | 16:31:00
11:13:00 | To B |  |  |  | 17:32:00 | 16:51:00
11:14:00 | To A |  |  |  | 17:52:00 | 17:11:00
11:33:00 | To B |  |  |  | 18:18:00 | 17:31:00
11:34:00 | To A |  |  |  | 18:44:00 | 17:51:00
11:53:00 | To B |  |  |  | 19:10:00 | 18:15:00
11:54:00 | To A |  |  |  | 19:34:00 | 18:39:00
12:13:00 | To B |  |  |  | 19:58:00 | 19:04:00
12:14:00 | To A |  |  |  | 20:28:00 | 19:28:00
12:33:00 | To B |  |  |  | 20:58:00 | 19:52:00
12:34:00 | To A |  |  |  | 21:28:00 | 20:16:00
12:53:00 | To B |  |  |  | 21:58:00 | 21:01:00
12:54:00 | To A |  |  |  | 22:28:00 | 21:33:00
13:13:00 | To B |  |  |  | 22:58:00 | 22:03:00
13:14:00 | To A |  |  |  | 23:29:00 | 22:33:00
13:33:00 | To B |  |  |  | 1900-01-01 00:09:00 | 23:04:00
13:34:00 | To A |  |  |  | 1900-01-01 00:49:00 | 23:34:00
13:53:00 | To B |  |  |  | 1900-01-01 01:29:00 | 1900-01-01 00:09:00
13:54:00 | To A |  |  |  |  | 1900-01-01 00:49:00
14:11:00 | To B |  |  |  |  | 1900-01-01 01:33:00
14:12:00 | To A
14:31:00 | To B
14:32:00 | To A
14:51:00 | To B
14:52:00 | To A
15:11:00 | To B
15:12:00 | To A
15:31:00 | To B
15:32:00 | To A
15:51:00 | To B
15:52:00 | To A
16:11:00 | To B
16:12:00 | To A
16:31:00 | To B
16:32:00 | To A
16:51:00 | To B
16:52:00 | To A
17:11:00 | To B
17:12:00 | To A
17:31:00 | To B
17:32:00 | To A
17:51:00 | To B
17:52:00 | To A
18:15:00 | To B
18:18:00 | To A
18:39:00 | To B
18:44:00 | To A
19:04:00 | To B
19:10:00 | To A
19:28:00 | To B
19:34:00 | To A
19:52:00 | To B
19:58:00 | To A
20:16:00 | To B
20:28:00 | To A
20:58:00 | To A
21:01:00 | To B
21:28:00 | To A
21:33:00 | To B
21:58:00 | To A
22:03:00 | To B
22:28:00 | To A
22:33:00 | To B
22:58:00 | To A
23:04:00 | To B
23:29:00 | To A
23:34:00 | To B
1900-01-01 00:09:00 | To B
1900-01-01 00:09:00 | To A
1900-01-01 00:49:00 | To B
1900-01-01 00:49:00 | To A
1900-01-01 01:29:00 | To A
1900-01-01 01:33:00 | To B