Question

ue fechat do you mean by dato Consolidation ? Live an example with steps:​

Answer 1

Answer:

Data consolidation is the corralling, combining, and storing of varied data in a single place. The term sometimes is used interchangeably with data integration. Data consolidation enables businesses to streamline their data resources, discover patterns, and look for insights in multiple types of data.

• Step 1: Open all files (workbooks) that contain the data you want to consolidate.
• Step 2: Ensure the data is organized in the same way (see example below).
• Step 3: On the Data ribbons, select Data Tools and then Consolidate. Step
• 4: Select the method of consolidation (in our example, it's Sum).