I need to combine 2 matrices via the "Matching Rows by Name" tool (settings I use are in the attched photo 2).

Because the "other matrix" has rows that the base matrix does not have I use the Join style "Outer".

That works perfectly except that it only adds the values of the text column that I matched, namely Protein.Group. The other values for protein names, genes and first.protein.description are then empty in the combined matrix (see photo) - only for the additional rows that the base matrix does not have.

I played around with all the settings but I can't find a solution for this. It either leaves those columns blank or it adds them in addition, so that I have a bunch of copied columns next to eachother.