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"]

     

AlexisOlson's avatar
AlexisOlson
Super User
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"]