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 Transpose Data in Excel
A handy little tip from the Paste options in Excel
Copy then Paste and select the Transpose option.
It doesn't work if you Cut - only Copy and not next door - select a cell underneath or on a new sheet.
365 Productivity
How to Manage Duplicate Data in Excel
Managing duplicates in Excel can often be a daunting task, but with a few simple steps, you can easily identify, filter, and remove them to ensure your data is as accurate and clean as possible.
365 Productivity
How to find emails in Outlook by Date
Click the Search bar to activate it - and from there use Advanced Search features to drill down to the required dates.