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
PowerPoint Animation - Gold star tips for making it work!s
Are you looking to make your PowerPoint presentations more engaging and dynamic? In this blog and video Kelly shared some invaluable tips for effectively working with animation in PowerPoint slides.
365 Productivity
How to check attendees availability before sending a Teams invite
Check before you schedule your next meeting and make sure everyone is available - then press Send!
365 Productivity
Discover the New Outlook Features: Snooze and Org Explorer
Outlook has introduced two amazing new features: Snooze and Org Explorer. With Snooze, you can temporarily remove emails from your inbox and bring them back at a time that suits you, helping you stay organised and stress-free. Org Explorer lets you easily navigate your company's structure, making it simple to find colleagues and understand reporting lines. Give these features a try and see how they can enhance your productivity and connectivity!