Case 7

When it comes to consolidating data by columns, people would have immediately thought using VLOOKUP. But when it comes to consolidating data from multiple sources with the same column, people would resort to manual copy and paste. In this example, we will show you that MSQuery can be put to good use and help you consolidate data in minutes and you don’t have to worry that the columns are not in the same sequence across the source files.

7.1-7.3 Add Multiple Entries & Consolidate Data

7.2 Remove Duplicate Records from the Database

 

Quick Access to the other Hidden Secrets in Data Analysis with Excel cases.

Case 1

Case 2

Case 3a

Case 3b

Case 4

Case 5

Case 6

Case 7