Write down the steps to consolidate data of two sheets into a separate sheet.
Answers
Answered by
3
Answer: Combine by category
Open each source sheet.
In your destination sheet, click the upper-left cell of the area where you want the consolidated data to appear.
On the Data tab, in the Data Tools group, click Consolidate.
In the Function box, click the function that you want Excel to use to consolidate the data.
Similar questions