We don’t need to bring in member ID, as it’s already a column in our member info dataset. Here, we’re going to select the columns that we want from our member loans dataset.
When we’re finished, we’re going to click on the icon next to “member_loans” to expand the dataset we just brought in.
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.