It is necessary that Excel return the names of the row and column if it sees a unit at their intersection. And so on for all rows. Can you tell me?

Question

Macros

Based on the original table, you need to create a correspondence between the number (columns) and the attribute (rows).

Answer 1

IF, ROW, COLUMN.