Forum Discussion
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 ...
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.
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?
Yes might be best to try this before the "Use First Row As Headers" step
Many thanks for your help.
I tried it on a copy of the file, whilst awaiting your reply.
Thank you for your rapid responses.
It works prefectly !! 😊