How to demote Headers in Power BI query editor

Question

Can anyone explain how to demote headers in Power BI query editor?

Answer 1

Hi,

There are the steps which you can follow to demote any Header, let;s go through:

1. Import excel files into power BI (load the data).
2. Click on Home-> (right hand side) use first row as header-> use header as first row.
3. Click on Transform Ribbon-> transpose.
4. Right click on Column-> transform-> Trim.
5. Transpose again.
6. Again go click on home-> use first row as header-> Replace Value.

Using these steps you will be able to demote any header you want.

I hope these will be helpful for you. 

If you are interested in learning Power BI then check out Power BI Course Details now!