How to Merge data from Two Spreadsheets based on a common attribute
This post is about generating a combined report off two different Spreadsheets. The use case is as follows - you have data from two different Excel spreadsheets and need to merge or combine the two spreadsheets into a single Spreadsheet based on a common attribute. For example, say you have two Spreadsheets about Employees in one spreadsheet as below with their First Name, Last Name, Department and email. First Name Last Name Department email Alice King Database king.alice@abc.com Bob Martin Networking martin.bob@abc.com Frank Jones Operations jones.frank@abc.com Alex Miller Engineering miller.alex@abc.com Simmons Young Database young.simmons@abc.com Greg Baker Software Dev baker.greg@abc.com Harry Walker ESD walker.harry@abc.com Edward Johnson Config Management johnson.edward@abc.com Phil Evans Operations evans.phil@abc.com Adam Morgan Infrastructure morgan.adam@abc.com And a second spreadsheet which has data about the employees Telephone and ...