Hi community, Can you please help with formating from before to after, base on the same person and sum days, group by if they are in consecutive days, note that the Days column is always 1.
Please see the following, hope this make sense, thank you
BEFORE:
| Name | From | Days | To |
| A | 2025-10-06 | 1 | 2025-10-07 |
| A | 2025-10-07 | 1 | 2025-10-08 |
| A | 2025-10-15 | 1 | 2025-10-16 |
| A | 2025-10-16 | 1 | 2025-10-17 |
| B | 2025-06-16 | 1 | 2025-06-17 |
| B | 2025-06-17 | 1 | 2025-06-18 |
| B | 2025-10-14 | 1 | 2025-10-15 |
| B | 2025-10-15 | 1 | 2025-10-16 |
| B | 2025-11-10 | 1 | 2025-11-11 |
AFTER:
| Name | From | Days | To |
| A | 2025-10-06 | 3 | 2025-10-09 |
| A | 2025-10-15 | 2 | 2025-10-17 |
| B | 2025-06-16 | 2 | 2025-06-18 |
| B | 2025-10-14 | 2 | 2025-10-16 |
| B | 2025-11-10 | 1 | 2025-11-11 |
