Combing each row of a list of lists into one

[danextian]

This is  not an urgent concern but I am just curious how to do this without actually converting the list to table.

let
    StartDate= DateTime.Date(DateTime.LocalNow()),
    EndDate= Date.AddYears(StartDate,-2),
    #"List of Lists" = List.Zip({ List.Generate( ()=>EndDate, each _ <= StartDate, each Date.AddDays(_,1)),  List.Generate( ()=>StartDate, each _ >= EndDate, each Date.AddDays(_,-1))}),
    #"Converted to Table" = Table.FromList(#"List of Lists", Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Extracted Values" = Table.TransformColumns(#"Converted to Table", {"Column1", each Text.Combine(List.Transform(_, Text.From), ","), type text}),
    Column1 = #"Extracted Values"[Column1]
in
    Column1

In the script above, I would like to insert a step after #"List of Lists" that will combine the list of lists for each row into just one list. I've tried List.Transform but I couldn't get it right.

[v-chuncz-msft · Accepted solution]

@danextian,

You may refer to the code below.

    Column1 = List.Transform(#"List of Lists"
                            , each Text.Combine(List.Transform(_, each Text.From(_)), ","))