Hello. I have a data file that splits out account details on separate rows if there is a date range that crosses a month end. For example, if Account A had a date range from 03/01/2021 to 04/26/21, then the file will list that account detail out on two rows: one with the date range of 03/01/2021-03/31/2021 and the next on 04/01/2021-04/26/2021. These files come from a separate entity and I'm sure they have a reason for doing this, but I would like to find something that will go through the listing and identify duplicated account numbers and merge them on a new row while connecting the dates. This should only be done if the dates are true broken connections (i.e.; a range of 03/01/2021-03/31/2021 would not be connected with the same account's 04/05/2021-04/16/2021 date range). Example data is provided below. Thanks in advance!
|Acct #||Date Begin||Date End|