Hi @Ilya2004,
if i understand you correct you want join data cell based and not column based or does the cell position (column, row) and the cell content should be considered?
Did you thought about first unpivoting the data therefore you have the option to join the data
a) based on the cell value or
b) based on the cell value and column name or
c) based on the cell value, column name and row number
afterwards you can pivot your final result to see onyl the data which matchs all your conditions.
In general your example does not make sence for me. Because your results represent finaly only your first table with blank values. Do you have additional information which you want to join and how is the logic behind that. Maybe it would be helpful if you could provide a more spelling example with input and expected output. In best case you provide (upload) the example files to make it easier for the rest of the community to coming up with suggestions or solutions.
BR