Hi guys,
I have a situation which I am trying to solve but got a bit stuck on it.
So I have the following data:
| ID | DATE | SEQ | |
| 1 | 01/01/2025 | 1 | |
| 2 | 02/01/2025 | 1 | |
| 2 | 04/01/2025 | 2 | |
| 2 | 06/01/2025 | 3 | |
| 3 | 05/03/2025 | 1 | |
| 4 | 07/02/2025 | 1 | |
| 5 | 01/03/2025 | 1 | |
| 5 | 03/03/2025 | 2 | |
| | | | |
My objective is the below in column DATE2:
| ID | DATE | SEQ | DATE2 |
| 1 | 01/01/2025 | 1 | 01/01/2025 |
| 2 | 02/01/2025 | 1 | 06/01/2025 |
| 2 | 04/01/2025 | 2 | 06/01/2025 |
| 2 | 06/01/2025 | 3 | 06/01/2025 |
| 3 | 05/03/2025 | 1 | 05/03/2025 |
| 4 | 07/02/2025 | 1 | 07/02/2025 |
| 5 | 01/03/2025 | 1 | 03/03/2025 |
| 5 | 03/03/2025 | 2 | 03/03/2025 |
Much appreciated any advice.
Kind Regards,
Dan
