Saturday, January 1, 2022

Promote a row to column headers power query

When a table is created, Power Query often automatically detects column headers and promotes them if necessary. However, you can also promote a first row to column headers or demote column headers to the first row when you need to.

Your browser does not support video.

Procedure

  1. To open a query, locate one previously loaded from the Power Query Editor, select a cell in the data, and then select Query > Edit. For more information see Create, load, or edit a query in Excel.

  2. Do one of the following:

    • To promote the first row to column headers, select Home > Use First Row As Headers.

    • To demote column headers to the first row, select Home, select the arrow next to Use First Row As Headers, and then select Use Headers as First Row.

See Also

Power Query for Excel Help

Promote or demote column headers (docs.com)

2 comments:

  1. Hello guys, I just want to share my joyful experience about HACK VANISH CREDIT SPECIALIST. Before the coronavirus pandemic, I had criminal Judgments, few evictions, and late payment which negatively impacted my credit score down to 487 and left me in difficult financial situation, as a single mum of 3, I needed a loan to keep the family running after I lost my husband as a result of COVID-19, all hope were lost, until Mrs. Olivia referred me to HACK VANISH, a credit genius who was very helpful in fixing my credit 6 days after I reached out to him via Email: hackvanish (At) gmail (Dot) com and Phone: +1(747) 293-8514, throughout the process, I felt so involved because an open line of communication was maintained till I got my FICO score restored to 796, currently my loan application has been approved. If you need to hire a credible hacker, HACK VANISH is highly recommended.

    ReplyDelete
  2. Best Hacker Contact RecoveryMasters

    I was in need of a very good hacker then i was referred to these wonderful hackers named RecoveryMasters who helped me hack into my spouse phone without my spouse knowing such a hack was done on his phone RecoveryMasters hacked into my spouse whats-app messages, call logs, text messages, deleted text messages, Viber, emails and many more i got result under 24 hours and I found out my spouse has been a big time cheat thanks to these great hackers you all can also contact them via email ( Recoverymasters@email.cz ) or whatsapp +1(551) 202-23-35 if you have any form of problem. They are solution makers. Tell them Hina referred you to them and I am sure they will help you with your proof.

    ReplyDelete