I'm trying for a solution where multiple columns has datetime as below table, I've tried using multirow formula "IF ID = Row-1:ID And End = Row-1:Start and applied rank formula but I'm not getting expected output.
| ID | Start | End |
| 1 | 12/29/2021 8:07 | 12/29/2021 8:30 |
| 1 | 12/29/2021 8:30 | 12/29/2021 9:00 |
| 1 | 12/29/2021 9:00 | 12/29/2021 9:30 |
| 1 | 12/29/2021 9:30 | 12/29/2021 10:00 |
| 1 | 12/29/2021 10:00 | 12/29/2021 10:30 |
| 1 | 12/29/2021 13:00 | 12/29/2021 13:30 |
| 1 | 12/29/2021 13:30 | 12/29/2021 14:00 |
| 1 | 12/29/2021 14:00 | 12/29/2021 14:30 |
| 1 | 12/29/2021 14:30 | 12/29/2021 15:00 |
| 1 | 12/29/2021 15:00 | 12/29/2021 15:30 |
| 1 | 12/29/2021 15:30 | 12/29/2021 16:00 |
| 1 | 12/29/2021 16:00 | 12/29/2021 16:30 |
| 1 | 12/29/2021 16:30 | 12/29/2021 17:00 |
| 1 | 12/30/2021 7:00 | 12/30/2021 7:30 |
| 1 | 12/30/2021 7:30 | 12/30/2021 8:00 |
| 1 | 12/30/2021 8:00 | 12/30/2021 8:30 |
| 1 | 12/30/2021 9:51 | 12/30/2021 10:00 |
| 1 | 12/30/2021 10:00 | 12/30/2021 10:30 |
| 1 | 12/30/2021 13:00 | 12/30/2021 13:30 |
| 1 | 12/30/2021 13:30 | 12/30/2021 14:00 |
| 1 | 12/30/2021 14:00 | 12/30/2021 14:30 |
| 1 | 12/30/2021 14:30 | 12/30/2021 15:00 |
| 1 | 12/30/2021 15:00 | 12/30/2021 15:30 |
| 1 | 12/30/2021 15:30 | 12/30/2021 16:00 |
| 1 | 12/30/2021 16:00 | 12/30/2021 16:30 |
| 1 | 12/30/2021 16:30 | 12/30/2021 17:00 |
| 1 | 12/25/2021 7:00 | 12/26/2021 16:00 |
| 1 | 12/26/2021 7:00 | 12/27/2021 17:00 |
And I'm trying to find a solution where to get an output as below
| ID | Start | End |
| 1 | 12/29/2021 8:07 | 12/29/2021 10:30 |
| 1 | 12/29/2021 13:00 | 12/29/2021 17:00 |
| 1 | 12/30/2021 7:00 | 12/30/2021 10:30 |
| 1 | 12/30/2021 13:00 | 12/30/2021 17:00 |
| 1 | 12/25/2021 7:00 | 12/26/2021 16:00 |
| 1 | 12/26/2021 7:00 | 12/27/2021 17:00 |
Thanks for the help in advance.
