Forum Discussion

Jojojojo's avatar
Jojojojo
Frequent Visitor
3 years ago
Solved

How do you append multiple columns into one column?

Hi there, I'm pretty new to Power Query and am looking to append 5 diffrent columns into one. From my formula below, the new column only seems to populate data from the columns ([Initiative Des...
Need Help
  • AlexisOlson's avatar
    AlexisOlson
    3 years ago

    If I'm understanding correctly, this seems like a good use case for the coalesce operator.

    [Initiative Description] ?? [#"MAT - Initiative Description"] ?? [#"ENG - Initiative description"] ?? [#"WAT -Initiative description"] ?? [#"OTH - Initiative description"]

     

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

=let col=List.Select(Table.ColumnNames(#"Added Custom3"),each Text.EndsWith(_,"Initiative Description",Comparer.OrdinalIgnoreCase)) in Table.AddColumn(#"Added Custom3","Initiative Descriptin All",each List.RemoveNulls(Record.ToList(Record.SelectFields(_,col))){0}?)