![Sophos reviews](https://knopkazmeya.com/15.png)
![how to get power query in excel 2007 how to get power query in excel 2007](https://images.techhive.com/images/article/2015/11/01-power-query-options-100630825-orig.png)
![how to get power query in excel 2007 how to get power query in excel 2007](https://www.computersolutionseast.com/wp-content/uploads/2020/11/excel-data-types-power-query-.gif)
Here, to combine the data of the three sheets we have created a new sheet named VLOOKUP where we have pasted the common data of the Product and Sales Person column and now we will combine the sales data from the three sheets by using the VLOOKUP function. Method-2: Using Excel VLOOKUP Function to Combine Sheets Similarly, repeat this referencing task for the other two sheets February and Marchįinally, you will get the sales values summed up for each product. In this way, the reference will be added up in the All references box ➤ Select Sum Option (or any other option as per your needs) in the Function boxĪfter that, we have selected the data of the Sales column of the January sheet in the Reference box ➤ Go to Data Tab > Data Tools Group > Consolidate Option ➤ Select the cell D5 (where you want to have the consolidated data) Here, we will use the Consolidate option, to sum up, the sales value of the three months of the three sheets January, February, and March for each product. Method-1: Using Consolidate Option in Excel to Combine Sheets
![how to get power query in excel 2007 how to get power query in excel 2007](https://www.spreadsheetweb.com/wp-content/uploads/2018/01/powerq7.png)
In these data tables, the first two columns are the same for all of the sheets but the only difference is in the value of sales.įor creating the article, we have used Microsoft Excel 365 version, you can use any other versions according to your convenience. Here, we have three sheets named January, February, and March containing sales records of these months.
![Sophos reviews](https://knopkazmeya.com/15.png)