How to combine two excel sheets together

Question

I got two .csv files with the exact same column and row annotations. They differer in the values in the sheets.

I want to combine these sheets into one sheet, adding all the values.

Any ideas on how to do this?

Answer 1

Open it up in notepad, remove the headers and copy paste the one below the other. Take extra care not to leave any additional space in the file. You can verify that it is ok by opening it up in excel afterwards.