Combine Multiple Worksheets Into One Sheet - Choose a place for the. Go the ‘from other sources’ option. Decide how to consolidate records. Let’s say, we have two different datasets. Select the worksheets to merge and calculate. Consolidate data from multiple worksheets in a single worksheet. In the get & transform data group, click on the ‘get data’ option. Web go to the data tab.
Let’s say, we have two different datasets. In the get & transform data group, click on the ‘get data’ option. Go the ‘from other sources’ option. Select the worksheets to merge and calculate. Consolidate data from multiple worksheets in a single worksheet. Choose a place for the. Decide how to consolidate records. Web go to the data tab.