How to use Power Query to make First Row into Headers
It's simple with Power Query - make sure your data is a Table to start with, use the Shortcut Ctrl + T. Then click into Data> Get Data from Table to open up Power Query.
Power Query has all sorts of tools and the more you familiarise yourself with them, the quicker you can work to clean and transform any data problem you may be facing.
Inside Power Query go to the Transform Ribbon. There is an icon on the left to ‘Use first row as headers’.
Now close and load back into Excel - Easy!
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
Teams
Create a Channel for Approvals in Teams
Approvals is a helpful App inside Teams - but how handy to have a dedicated channel in your Team site so everyone can have visibility of your Approvals back and forward.
365 Productivity
Power Query to Fill Up and Fill Down - super quickly!
Jump in and out of Power Query to clean your data - even for pesky small jobs - so much quicker!
365 Productivity
Windows 11 - Where is my navigation pane?
It was lost but now it is found! We can't do much without our Navigation pane to find our files, so when it's missing - life is difficult.
What's worse is that it isn't that intuitive to find it, but like anything - it's easy when you know how!