Copy to Summarise data based on 2 criteria: User ID and gaps in continuous day segments for same user

[ayazgreat]

my three cents with Power Query

Numbers	ID	StartDate	EndDate
12345	22	03/01/2022	06/01/2022
23456	22	03/01/2022	04/01/2022

// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Type = Table.TransformColumnTypes(Source,{{"Numbers", Int64.Type}, {"ID", type text}, {"Date", type date}}),
    Group = Table.Group(Type, {"Numbers", "ID"}, {{"StartDate", each List.Min([Date]), type date}, {"EndDate", each List.Max([Date]), type date}})
in
    Group

Thanks for your reply I just want to know that where should I copy these power query code to run further I have 5 lacs rows of data so how much does it take time to complete ?