Forum Discussion

Hernán's avatar
Hernán
Frequent Visitor
3 years ago
Solved

Option "Merge columns" in menu Transform - Power Query isn't available - how I can activate it?

Hello everyone, I hope you are doing well!   I need to use the option "merge columns" in Power Query (in Power BI) but it is not available. The PBI version is: 2.118.828.0 64 bit (June 2023...
  • ronrsnfld's avatar
    3 years ago

    First select two or more columns. The option is not available unless you have previously selected the columns you wish to merge.

     

  • tackytechtom's avatar
    3 years ago

    Hi Hernán ,

     

    I am trying to reproduce the issue... It's not like that you only have selected one column, is it? When I select only one column, then the Merge Columns is greyed out, when I select two (by holding ctrll) the Merge Column button gets enabled.

     

    Otherwise, feel free to share the a screenshot of the whole screen and I am sure we can help you!

     

    Thanks,

     

    /Tom
    https://www.tackytech.blog/
    https://www.instagram.com/tackytechtom/