Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Remove Blank Columns

Hello How can I remove blank columns in Power BI Power Query Editor. I have a report that returns columns with nothing in.  I can't select columns and remove selected, as future runs of the source ...
Need Help
  • Adescrit's avatar
    Adescrit
    4 years ago

    In Power Query, go to the Transform tab. Then select Transpose (Top-left of screen)

     

    Then back to the Home tab and select Remove Rows > Remove Blank Rows (these blank rows were your blank columns prior to transposing)

     

    Finally Transform > Transpose once more.

Adescrit's avatar
Adescrit
Impactful Individual
4 years ago

In Power Query you can Transpose your table. Then if you filter out / remove blank rows (these were columns prior to the transpose step) before transposing once more to return your table to its original layout.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Adescrit

    Thank you

    Is this the Transform/Unpivot Columns/Unpivot Columns?

    Then would I follow up with Remove Blank Rows, followed by Transform/Unpivot Columns/Unpivot Columns?

    Please can you confirm my understanding?

    Thank you

    • Adescrit's avatar
      Adescrit
      Impactful Individual
      4 years ago

      In Power Query, go to the Transform tab. Then select Transpose (Top-left of screen)

       

      Then back to the Home tab and select Remove Rows > Remove Blank Rows (these blank rows were your blank columns prior to transposing)

       

      Finally Transform > Transpose once more.

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Adescrit

        Thank you, but...

        When I Transpose back to the original format - I have lost all of my column names.

        Should I do this step directly after the Navigation Step?