Hello All,
I am trying to get a report where a particular cell data which is dynamic and i need to replace it with another cell data.
| Number | value | start | stop |
| 1 | CD | 01-01-2023 00:00 | |
| 1 | AD | 01-01-2023 00:00 | 03-01-2023 00:00 |
| 1 | AD | 03-01-2023 00:00 | 04-01-2023 00:00 |
| 1 | AD | 04-01-2023 00:00 | 05-01-2023 00:00 |
| 1 | AD | 05-01-2023 00:00 | 06-01-2023 00:00 |
| 1 | AD | 06-01-2023 00:00 | 07-01-2023 00:00 |
| 1 | AD | 07-01-2023 00:00 | 13-01-2023 00:00 |
| 1 | RD | 08-01-2023 00:00 | 13-01-2023 00:00 |
| 2 | AD | 09-01-2023 00:00 | 10-01-2023 00:00 |
| 2 | CD | 10-01-2023 00:00 | |
| 2 | CD | 11-01-2023 00:00 | 12-01-2023 00:00 |
| 2 | CD | 12-01-2023 00:00 | 13-01-2023 00:00 |
| 2 | AD | 13-01-2023 00:00 | 14-01-2023 00:00 |
| 2 | AD | 14-01-2023 00:00 | 15-01-2023 00:00 |
| 2 | AD | 15-01-2023 00:00 | 19-01-2023 00:00 |
| 2 | RD | 16-01-2023 00:00 | 19-01-2023 00:00 |
| 3 | AD | 17-01-2023 00:00 | 18-01-2023 00:00 |
| 3 | CD | 17-01-2023 00:00 | |
| 3 | AD | 19-01-2023 00:00 | 20-01-2023 00:00 |
| 3 | AD | 20-01-2023 00:00 | 21-01-2023 00:00 |
| 3 | AD | 21-01-2023 00:00 | 22-01-2023 00:00 |
| 3 | AD | 22-01-2023 00:00 | 23-01-2023 00:00 |
| 3 | AD | 23-01-2023 00:00 | 24-01-2023 00:00 |
| 3 | RD | 27-01-2023 00:00 | 28-01-2023 00:00 |
| 3 | AD | 25-01-2023 00:00 | 26-01-2023 00:00 |
| 3 | AD | 26-01-2023 00:00 | 28-01-2023 00:00 |
Here i am trying to replace the "RD start date" on corresponding number's last "AD end date".
For example:
| Number | value | start | stop |
| 1 | CD | 01-01-2023 00:00 | |
| 1 | AD | 01-01-2023 00:00 | 03-01-2023 00:00 |
| 1 | AD | 03-01-2023 00:00 | 04-01-2023 00:00 |
| 1 | AD | 04-01-2023 00:00 | 05-01-2023 00:00 |
| 1 | AD | 05-01-2023 00:00 | 06-01-2023 00:00 |
| 1 | AD | 06-01-2023 00:00 | 07-01-2023 00:00 |
| 1 | AD | 07-01-2023 00:00 | 13-01-2023 00:00 |
| 1 | RD | 08-01-2023 00:00 | 13-01-2023 00:00 |
I want to replace "AD End date (Here 13-01-2023 00:00)" with "RD Start date (Here 08-01-2023 00:00)".
i want to repeat this for 100+ numbers.
Anybody have any idea on this ??
Thank you.
