Consolidating worksheets in excel
Because of this each question may not be in the same cell.6. Alternatively, you can use Power Query in Excel 2013, renamed Get and Transform in Excel 2016, but those features require far more experience with database queries than the average Excel user has accumulated at this point.
Here we look at: NOTE: The following processes will work in Excel versions: 2007, 2010, 20.
There is a quick and easy way to do this – using the Data Consolidation tool.
In this blog, Edmund, one of our Excel experts, shares his top tips.
You can keep adding Union and Select statements as needed.
Figure 4: You can display the combined data in Excel in a variety of ways.