let
    listToText = (items) => Text.Combine(items, "/"),
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Duplicates" = Table.Distinct(Source),
    #"Sorted Rows" = Table.Sort(#"Removed Duplicates",{{"Магазин", Order.Ascending}, {"Столбец1", Order.Ascending}}),
    #"Pivoted Column" = Table.Pivot(#"Sorted Rows", List.Distinct(#"Sorted Rows"[Магазин]), "Магазин", "Столбец1", listToText)
in
    #"Pivoted Column"

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Removed Duplicates" = Table.Distinct(Source),
    #"Added Custom" = Table.AddColumn(#"Removed Duplicates", "marker", each "x"),
    #"Sorted Rows" = Table.Sort(#"Added Custom",{{"Магазин", Order.Ascending}}),
    #"Pivoted Column" = Table.Pivot(#"Sorted Rows", List.Distinct(#"Sorted Rows"[Магазин]), "Магазин", "marker")
in
    #"Pivoted Column"

let
    getMinuteInterval = (timeTextInterval) =>
    let
        timeTextList = Text.Split(timeTextInterval, "-"),
        timeList = List.Transform(timeTextList, each Time.From(_)),
        minuteCount =  Duration.TotalMinutes(timeList{1} - timeList{0}) + 1,
        timeMinuteInterval = List.Times(timeList{0}, minuteCount, #duration(0, 0, 1, 0))
    in
        timeMinuteInterval,
    testInterval = "10:00-20:00",
    result = getMinuteInterval("10:00-20:00")
in
    result

Number.ToText(Date.WeekOfYear(#date(2019, 03, 21)), "00")

if [c1] > 5 and [c2] < 11 then "x" else if [c1] > 12 and [c2] < 23 then "y" else "z"

let
    Source = Excel.CurrentWorkbook(){[Name="Таблица1"]}[Content],
    addId = Table.AddIndexColumn(Source, "id", 100),
    defineRow = Table.AddColumn(addId, "row", each [id] - [Столбец1]),
    removeId = Table.RemoveColumns(defineRow, {"id"}),
    pivoted = Table.Pivot(Table.TransformColumnTypes(removeId, {{"Столбец1", type text}}, "ru-RU"), List.Distinct(Table.TransformColumnTypes(removeId, {{"Столбец1", type text}}, "ru-RU")[Столбец1]), "Столбец1", "значение Y"),
    removeRow = Table.RemoveColumns(pivoted, {"row"})
in
    removeRow