LibreOffice Calc: How to merge two data sheets into a third

[mr.raccoon]

Hey,

I have to sheets of data containing a list of species from two samples.
Each species (rows) is marked with ID in one column, the number occurrence in a second, and their phylum, family, genus, species name etc. in the following columns.

Now I want to merge the two separate sheets in a third sheet giving me the total number of occurrence per species and overall occurrence. The column structure should stay the same.

Thanks a lot!

[anon73440385]

Though from a screenshot I’m unable to understand your real goal, you may be interested in Data -> Consolidate functionality: LibreOffice Help - Consolidating Data

[mr.raccoon]

I have two data sheets like this. In the end I want to have one sheet where based on the taxon_id the number of reads is presented as the sum of sheet1+sheet2. All the other columns should be added accordingly