How to Import data from a folder with multiple files - Power Query
How to Import data from a folder with multiple files
Are you tired of manually combining data from various Excel files? This quick and easy tutorial will show you how to use Excel Power Query to automate this process and save countless hours! In just a few simple steps, you’ll learn how to combine data from a folder full of files into a single, organized table.
Timestamps:
00:00 - Intro
00:09 - Open Excel and Get Data
00:23 - Find and Select the Folder
00:31 - Combine and Load the Files
00:56 - Enjoy the Result
01:03 - Editing Queries
01:30 - Refresh Data
'Excel Explained: Basics' Playlist:
• EXCEL: BASICS