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?

      • Adescrit's avatar
        Adescrit
        Impactful Individual
        4 years ago

        Yes might be best to try this before the "Use First Row As Headers" step