Multiple consecutive weeks merge

[aroumpelaki]

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? 

[messi007]

Hello @aroumpelaki,

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

It will help us to give you the solution.

Regards,

[Ladarthure · Accepted solution]

Hi @aroumpelaki,

to do this, you can process in 3 steps :

1. sort your data by date (and eventually other attributes)
2. 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)
3. use a summarize to agregate

[aroumpelaki]

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

[messi007]

@aroumpelaki,

Please see below :

Attached the workflow,

Regards

[aroumpelaki]

Thank you very much! It works like a charm!

Once more the solution was so simple!

[aroumpelaki]

@messi007 this doesn't really do the trick, as I essentially was trying to identify periods of weeks.

@Ladarthure works just fine!

Thank you both for your time and suggestions!