Group data and create columns for weekdays and Time values

Hi, I'd like to help you, but data in the link you've provided 

looks totally different compared to this one:

So how your data looks like?

This query is connected to your Google Drive excel worksheet. I've filtered top 1000 rows to make it faster (it loads 10 519 rows in result). As you can see, it works great. Regarding your issue: There is a problem that you have stored both "times" in Time1 column. Provide data with this issue and I can try to help you.

let
    Source = Excel.Workbook(Web.Contents("https://drive.google.com/uc?export=download&id=1htdH3Pd9GRSPRb5xuLJTh1CA7OhbKasH")),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    RenamedColumns = Table.RenameColumns(Sheet1_Sheet,{{"Column1", "Postal City Country"}, {"Column2", "Collect Point"}, {"Column3", "Date Time"}}),
    #"!!!_FilteredTOP1000Rows_!!!" = Table.FirstN(RenamedColumns, 1000),
    AddedIndex = Table.AddIndexColumn(#"!!!_FilteredTOP1000Rows_!!!", "Index", 0, 1, Int64.Type),
    Ad_DateTimeSplit = Table.AddColumn(AddedIndex, "DateTimeSplit", each List.Select(List.Transform(Text.Split([Date Time], "#(lf)"), (x)=> Text.Remove(x, {" ", "#(cr)"})), (y)=> Text.Length(y) > 1), type list),
    ExpandedDateTimeSplit = Table.ExpandListColumn(Ad_DateTimeSplit, "DateTimeSplit"),
    SplitColumnByDelimiter = Table.SplitColumn(ExpandedDateTimeSplit, "DateTimeSplit", Splitter.SplitTextByEachDelimiter({":"}, QuoteStyle.Csv, false), {"Date", "Time"}),
    RemovedColumns = Table.RemoveColumns(SplitColumnByDelimiter,{"Date Time"}),
    GroupedRows = Table.Group(RemovedColumns, {"Index", "Date"}, {{"All", each Table.AddIndexColumn(_, "ID", 1, 1, Int64.Type), type table}}),
    CombinedAll = Table.Combine(GroupedRows[All]),
    Transformed = Table.TransformColumns(CombinedAll,
        { {"Collect Point", each Text.Combine(Text.Split(Text.Remove(_, {",", "#(cr)"}), "#(lf)"), ", "), type text},
          {"ID", each "Time" & Text.From(_, "sk-SK"), type text} })
in
    Transformed

Hi Dufo,

Thanks for your support.

i will attach the source data sheet with hours splitted for each weekday so that you can help.

Attached source data. google drive link

https://docs.google.com/spreadsheets/d/12PD4hCdT0pEacfRP_oUYUuYeEnZVmkt2/edit?usp=drive_link&ouid=107322499030709606985&rtpof=true&sd=true 

Only for friday the ID is showing 1 and 1 instead of 1 and 2.

https://docs.google.com/spreadsheets/d/1kMgzehh1inILMJ7VA-EuHR36vsv53JcO/edit?usp=sharing&ouid=107322499030709606985&rtpof=true&sd=trueGoogle  

Only for friday the ID is showing 1 and 1 instead of 1 and 2.

I see that there are some discrepancies (see Check column), but I don't see your source data, so I can't help you...

let
    Source = Excel.Workbook(Web.Contents("https://drive.google.com/uc?export=download&id=1kMgzehh1inILMJ7VA-EuHR36vsv53JcO")),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    PromotedHeaders = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    GroupedRows = Table.Group(PromotedHeaders, {"Index", "Date"}, {{"All", each Table.AddIndexColumn(_, "ID dufoq3", 1, 1, Int64.Type), type table}}),
    CombinedAll = Table.Combine(GroupedRows[All]),
    Ad_Check = Table.AddColumn(CombinedAll, "Check", each [ID]=[ID dufoq3], type logical)
in
    Ad_Check

Hi Dufo,

Final output is time1 and time 2 which is not working for friday,

https://docs.google.com/spreadsheets/d/12PD4hCdT0pEacfRP_oUYUuYeEnZVmkt2/edit?usp=drive_link&ouid=10...  

Attached google drive link

I'm sorry but I give up. I've asked for data with this issue, but you either not read what i write or you're kidding...

I will not response to this thread anymore. I recommend you to creat new one with sample data covering your issue in usable format and expected result based on sample data.