How to consolidate row values ​​or data into a spreadsheet in Excel

Who I am
Marie-Ange Demory

Author and references

The Excel tool allows you to create tables and documents in a very simple way, which allows you to have adequate control over institutions, jobs and companies. If you are interested in creating a good Excel table, you better know how to consolidate the values ​​or data of a row into a spreadsheet in Excel .

The consolidation tool present in Excel can be very useful for several circumstances. It is quite simple to use, in any case it usually generates big doubts in the novice users of this platform.

How to consolidate row values ​​or data into a spreadsheet in Excel

Don't worry, here you will learn how to use it very easily, but before you start we recommend that you are familiar with concepts such as inserting formulas into text boxes in Excel, fundamental aspects that you should master.

What is data consolidation in Excel?

When we use the term consolidate, we mean it to the unification of related data from multiple sheets, i.e. using the consolidate tool you can count or add cells in Excel and perform various mathematical operations in multiple tables and show the final result in a unified table.

This can be especially useful for keeping track of the inventory of multiple stores selling similar products. In this way, they are drawn conclusions as total sales, shopping Total and other factors, although clearly this function can be applied to any circumstance.

How to consolidate values ​​or data from a row into a worksheet in Excel

Using tools like Solver to solve mathematical equations and operations in Excel is an excellent idea to make your work easier and provide clearer data

Read How to save or reduce mobile data consumption on Instagram

This is exactly where data consolidation appears, as it is very useful to assume the full control data belonging to a document. In any case, there are a few things to keep in mind in order to apply this function correctly.

The data and its ranges must be the same

The best thing to do is that each of the rows you intend to consolidate has the same data type and the same length. Otherwise, conflicts are very likely to occur when viewing the totals.

For this reason, we recommend that you create before a model for each of the tables you want to create. This way you will avoid any inconvenience in using the consolidation function.

Consolidate data into an Excel sheet

  1. Insert the Excel document you created earlier. In case you haven't created a specific space for summary or data collection, it's time to do it.
  2. Position yourself in the space where you want the consolidated data to appear. You should now go to the section Data, located at the top of the screen.
  3. The option appears in this space Consolidate, the depending on the function you want to perform, you can use addition, subtraction, etc.
  4. Click on the section Reference, now go to the first table you want to include, select the whole table and click the option Add.
  5. Go to the rest of the tables, as the tables are the same, the system will detect them automatically and all you have to do is click on add (in case they are not detected automatically, select them manually). Repeat this procedure for each of the tables that you want to add to the consolidation.
  6. In the Use labels , select options Top row , Left column and we also recommend that you enable the option to create links with source data . Enabling the latter option will ensure that your data is automatically updated when you make changes.
  7. To create the consolidated table, do click on the option OKAY. This will display a general table with the totals present in each of the tables that compose it.
Read How to block background change in Windows 10 Regedit

Note that you can also consolidate data in Excel from multiple sheets into one, but this process is different from what we have shown before, to learn it you can visit the link above.

add a comment of How to consolidate row values ​​or data into a spreadsheet in Excel
Comment sent successfully! We will review it in the next few hours.