Combining text from two column's and creating a new list

Diamond Contributor

Feb 15, 2018

Microsoft Power Query for Excel is available for 32-bit (x86) and 64-bit (x64) platforms, your selection must match architecture of the installed version of Office.

https://www.microsoft.com/en-us/download/details.aspx?id=39379

Michael Colwell

Copper Contributor

Feb 16, 2018

Hi Sergi,

Thanks for the link, not sure how I missed that..!!

Have installed and will try to work through combining the column's as per my original post.

Regards.

Detlef_Lewin

Silver Contributor

Feb 16, 2018

Michael,

first change the list into an Excel Table (CTRL-T) and query from table.

And then change the preliminary code to:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Base Code", type text}, {"Variant", type text}}),
    #"Split Column by Delimiter" = Table.ExpandListColumn(Table.TransformColumns(#"Changed Type", {{"Variant", Splitter.SplitTextByDelimiter(",", QuoteStyle.Csv), let itemType = (type nullable text) meta [Serialized.Text = true] in type {itemType}}}), "Variant"),
    #"Changed Type1" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Variant", Int64.Type}}),
    #"Merged Columns" = Table.CombineColumns(Table.TransformColumnTypes(#"Changed Type1", {{"Variant", type text}}, "de-DE"),{"Base Code", "Variant"},Combiner.CombineTextByDelimiter("-", QuoteStyle.None),"Combined")
in
    #"Merged Columns"

Forum Discussion

Combining text from two column's and creating a new list

Resources