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