Forum Discussion

Dicko's avatar
Dicko
Icon for Helper II rankHelper II
4 years ago
Solved

Combine text from multiple columns in Power Query

Here's a table with the results I seek:   col_1  col_2  result ape  bee  ape,bee house  street  house,street   Now I have something like this (see below), where I collect eac...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Try this as the next step:

    = Table.AddColumn(#"Merged Columns", "Custom",
    (r) => Text.Combine(List.Transform(MyColumns, each Record.Field(r, _)), ","),
    type text)

     

    This turns the list of columns into the values in those columns and concatenates the list with Text.Combine.

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
4 years ago

Try this as the next step:

= Table.AddColumn(#"Merged Columns", "Custom",
    (r) => Text.Combine(List.Transform(MyColumns, each Record.Field(r, _)), ","),
    type text)

 

This turns the list of columns into the values in those columns and concatenates the list with Text.Combine.

SebSchoon1's avatar
SebSchoon1
Icon for Post Patron rankPost Patron
4 years ago

Wow Thanks it works perfectly !! Thank you mate!