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, I don't see a way not to lose them because if you first go from headers to the first row, when you transpose the first column it is not blank (they are the old headers) and the delete blank rows does not find any.