From the course: Excel: Power Query (Get & Transform)

Unlock the full course today

Join today to access over 23,100 courses taught by industry experts.

Query data from a folder and import multiple files

Query data from a folder and import multiple files - Microsoft Excel Tutorial

From the course: Excel: Power Query (Get & Transform)

Start my 1-month free trial Buy for my team

Query data from a folder and import multiple files

“

A common need is to get data all stacked up in one place. We have this Magician's Conference folder. Double-click it to see what's in there. We had a levitation workshop, magic as a business, and what to know about working in Las Vegas. Click on here and here's a preview. Right. A list of who was registered and who attended. Registered and attended. Registered and attended. We are going to use Power Query's Append function to get these all stacked up in one place. And the goal is to get it all stacked up so that we can sort by the names regardless of the workshop. But we do want to have a workshop column. Do we open these one at a time? Copy and paste them? Do we write a lot of formulas to get everything swept together? No. I'm going to open a workbook. Okay. And I don't like gridlines. Now, one thing that's important, with this type of Append, it is important to have all of the columns in the order that you want. In other types of Append, it's more important that the names be the…

Contents