Merge Countersignature Data with airSlate SignNow

Import data, Merge several documents and Sign

Today let's take a look at a common task you might have already come across, which is to combine multiple Excel files into one file. So for example, let's say you sent out a template to your colleagues to collect some data. You got them in separate files. Now you want to combine them. Basically, you want to consolidate or append the data in one single file. One solution has always been VBA, but this time we're going to use a simpler approach. We're going to use Get & Transform, also known as Power Query, from the data tab. (upbeat music) (air whooshing) (bubble popping) My aim is to combine the data from these files by directly connecting to the folder. Now, there are a few requirements. I don't want to include any files that don't have _Data in it, and I also want to be sure to exclude any non-Excel files. Let's quickly take a look at the content of the files. I have cells information for a specific month. The data is not in an Excel table. The structure of the files, though, are identical. They all have identical headers. Now, I want to make sure I exclude this file. Now, what want I want my end result to be is a PivotTable that combines the data from these files. I want to get a summary sales report by a company and customer. Let's open a blank workbook. Go to Data + Get Data + From File + From Folder. Browse for the folder. My files are sitting right here. OK and OK. Now, Power Query goes ahead, creates a connection to the folder and checks what's inside that folder. If all the data was in a proper format, if it only included the files that I need, I could go ahead and Combine & Load the data directly to the workbook, but I need to make some transformations on this. So let's go ahead and transform the data. Before I combine these files, which we can see right here, what I want to do is to filter out the files that I don't need. So I set that I don't need anything that doesn't have _Data. So for text filters, I want to include everything that contains _Data and OK. I also want to make sure I've restricted everything to Excel files, Begins With .xls and OK. Those are my two steps. Now I'm ready to go ahead and combine the content. All I have to do is click on this double-down arrow, Combine Files, and Power Query is going to bring up the navigator, asking me which tab or which data I want to combine. The decision I make here is based on a Sample File. So it's picked the first file, which is Bere Kleid in that folder. From this first file, I get to pick the tab that I want, and let's go with OK. Now, Power Query's going to go and try to...