Applicant ID Period Of Stay From Period Of Stay To What I want to achieve
2021/F/Q1/002 01/03/2020 31/03/2020 2021/F/Q1/002 Mar 2020 - May 2020
2021/F/Q1/002 01/04/2020 30/04/2020 2021/F/Q1/003 Mar 2020 - May 2020
2021/F/Q1/002 01/05/2020 31/05/2020 2021/F/Q1/004 Mar 2020 - Apr 2020
2021/F/Q1/003 01/03/2020 31/03/2020
2021/F/Q1/003 01/04/2020 30/04/2020
2021/F/Q1/003 01/05/2020 31/05/2020
2021/F/Q1/004 01/03/2020 31/03/2020
2021/F/Q1/004 01/04/2020 30/04/2020
Our in-house system will generate an excel report in which Column A: Applicant ID, Column B: Period of Stay From, Column C: Period of Stay To. I am seeking the community help to see if we are able to combine the records to show by Column D: Applicant ID and the Column E: Period Start and End Dates.
Thank you for reading my post.
Bookmarks