Find similar values in different column and generate a matrix

Dear all,

I wondering if there is a formula that could help me to obtain the following output (in orange) table :

formula

Thanks in advance

Hi MatthieuB08,

test this file if it's you're wondering.

Good evening.

12matthieub08.xlsx (10.58 KB)
Search for threads similar to "find similar values different column generate matrix"