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
365 Productivity
How to have fun with Line Graphs
Line graphs just got interesting - create an image or a shape. Copy - then Select your Line in your Line Graph - then paste.
365 Productivity
OneDrive - on your phone
Accessing your files on the go is just one benefit of OneDrive, the app. We love the scanner - take a scan of a receipt and file it directly, or better still scan and send to the Accounts team - they'll be so pleased, and you'll never have to fumble through expense claims again!
365 Productivity
How to play music in your next Microsoft Form
Now that's a fun idea from Microsoft - no more boring surveys! Why not add music to your next survey when you create your Microsoft Form