Consolidating data in excel
Choose a different delimiter for each column you want to merge.. Summarize data from a number of different tables quickly using consolidation.This chapter guides you through procedures related to using a workbook as a template for other workbooks, linking to data in other workbooks, and consolidating multiple sets of data into a single workbook.After you decide on the type of data you want to store in a workbook and what that workbook should look like, you probably want to be able to create similar workbooks without adding all of the formatting and formulas again.The only change you’ll make is with regard to the workbook and sheet names, so for this article we’ll assume you’re combining data from within the same workbook.
If all of the spreadsheets use the same category headings, you can merge data by category name regardless of where the categories and data are located on the spreadsheets.
Fortunately, Microsoft Query is an alternative that is available in all versions of Excel that can guide you through the process.
The process I’ll describe can work within an existing workbook, or you can pull data from multiple workbooks.
Excel 2016 gives you a wide range of tools with which to format, summarize, and present your data.
After you have created a workbook to hold data about a particular subject, you can create as many worksheets as you need to make that data easier to find within your workbook.