This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
You can do this by finding the first row of each period, then the last, removing all the rows between and changing the end row start date.
Note that from your input data it looks like as long as the start date of one row was the day after the end date of the previous row, the rows could be combined into a single period. If this is not correct, you'll have to provide the actual criteria