combine two columns in one

[Anonymous]

#"Merged Queries" = Table.NestedJoin(#"Replaced Value", {"Country"}, Table, {"Country_short"}, "Table", JoinKind.LeftOuter),

#"Expanded Table1" = Table.ExpandTableColumn(#"Merged Queries", "Table", {"Company", "Country"}, {"Table.Company", "Table.Country"})

How do I combine those two column in #'Expanded Table1'? In the end i want to have on string in one column like. Company & "(" & Country & ")"

[goncalogeraldes · Accepted solution]

Hi @Anonymous! You can try the following M code:

= Table.CombineColumns(#"Expanded Table1",{"Company", "Country"},Combiner.CombineTextByDelimiter(" - ", QuoteStyle.None),"Company - Country")

Please note that I used " - " as a separator for the column so change it according to your needs!

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!

You can also check out my LinkedIn!

Best regards,
Gonçalo Geraldes