how do i remove the row having the same data and also create new rows by splitting for example:insurance policy data Policyno. start_date end_date difference in dates 1 10mar2016 09mar2017 1year 1 10mar2016 09mar2017 1year 2 01apr2016 31jan2018 1year 10months 3 05may2016 04may2017 1 year 3 05may2017 04may2018 1 year what i want: 1)remove the field having the same data for eg of policyno. 1.I want only one field with unique data. 2)the difference should be not more than one year,if so then split the data into 2 rows or 3 rows depending on the difference for eg in policy no.2 difference is 1 year 10 months i want it to be split into 2 rows. Policyno. start_date end_date difference in dates 2 01apr2016 31mar2017 1year 2 01apr2017 31jan2018 10 months(which is less than 1 year) thankyou in advance
... View more