To merge these two datasets, we’re going to select “Merge Queries” and “Merge as New” so that we can have a separate space for our new dataset.Next, we’ll bring in our other dataset by selecting “New Source” and “Text/CSV” and we’ll see the dataset on loan information added to the left-hand side.We’ll start by importing our file on basic member info, which will bring us into the Power Query editor.You can also import Excel files by selecting “Get Data.” Next, we’ll click on the “Data” tab of our new worksheet and select “From Text/CSV” because the files that we’re working with are csv files.First, we’ll take a look at each dataset to roughly analyze their contents, and then open up a new worksheet for our merged dataset.
![combine cells in excel combine cells in excel](http://www.wikihow.com/images/e/e3/Merge-Cells-in-Excel-Step-4-Version-3.jpg)
Each dataset also contains a member ID, which will allow us to join the data on that common field in order to compare all of this data side by side. In this example, we’re using two individual datasets, the first containing basic member information, such as income, education, phone number, etc., and the second containing member loan information, such as the loan amount, interest rate, loan status, etc. Instead, let’s take a look at how we can do this same process all within the Excel Power Query editor. Traditionally, VLookup has been one of the most important tools for merging data in Excel, but the process requires multiple steps and can easily tire analysts who must merge multiple columns across many datasets. Then hit ‘OK,’ watch the data propagate, and begin reviewing or analyzing the new sheet. Important: Make sure the labels match.Under ‘Reference,’ select ‘Browse’ to identify the Excel workbooks you want to consolidate the data from.In this example, we’re using “Sum” to add together the total loans borrowed per member.
![combine cells in excel combine cells in excel](https://support.content.office.net/en-us/media/5b894c49-4288-495f-96b8-2844bd0a04b8.png)
COMBINE CELLS IN EXCEL HOW TO
You want to understand the total amount of loans borrowed by each member, so you may naturally wonder how to combine data in Excel. For this example, let’s say you are given two sets of data about the amount of loans a group of members have borrowed per year, each in an independent Excel workbook.