Question:
I need to get the start date and end date. help me please I have such a table:Answer:
This is a gaps and islands problem. One approach uses the difference in row numbers method:If you have better answer, please add a comment about this, thank you!