Forum Discussion
Remove Blank Columns
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.
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 !! 😊
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.
