Andy L.

Andy L. ITM, VUB

Temat: Identyfikatory w jednej kolumnie


Obrazek




let

    Source = Excel.CurrentWorkbook(){[Name="Table9"]}[Content],

    ROC = Table.ToColumns(Table.SelectColumns(Source,{"ID 2", "ID 22"})),

    ToTable = Table.FromList(ROC, Splitter.SplitByNothing(), null, null, ExtraValues.Error),

    Expand = Table.ExpandListColumn(ToTable, "Column1"),

    Rename = Table.RenameColumns(Expand,{{"Column1", "IDs"}})

in

    Rename
Link do wypowiedziLink