Multiple consecutive weeks merge

Hello!

I have been trying to merge consecutive weeks to one row with the minimum start date and maximum end date.

An example is shown below.

From:

To:

I have tried to use the multirow formula, but the problem is that the consecutive week number is indefinitely high.

Any thoughts on this?

Developer

Accepted answers

to do this, you can process in 3 steps :

sort your data by date (and eventually other attributes)
use a multi row formula to identify if weeks (or in your case start date from the current row is 1 more day than the end of previous row)
use a summarize to agregate

Could you share a sample data instead of a screen shot?

It will help us to give you the solution.

Regards,

to do this, you can process in 3 steps :

sort your data by date (and eventually other attributes)
use a multi row formula to identify if weeks (or in your case start date from the current row is 1 more day than the end of previous row)
use a summarize to agregate

You are right, I have uploaded the two tables I have used in the screenshots.

Thank you very much! It works like a charm!

Once more the solution was so simple!