Question

.Q.1. who I am.
.1. I combine the same type of data from different ranges or different spreadsheet.​

Answer 1

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, under Tools, click Consolidate.

In the Function box, click the function that you want Excel to use to consolidate the data.