How to get address Column Name and Row Name of all marked rows in Excel table as rows in new worksheet

Question

 need the row/column combinations marked with an 'X' in my table to be available as three columns in another sheet.

• The first column will consist of the cell address,
• the second column will have the Row Name, and
• the third column will have the Column name of the marked cells.

VLookUp and Index/Match are not helping.

Expected result:

Answer 1

Follow these steps to correct your behaviour:

Open Excel in your computer.
Options is found on the Tools menu.
Select Formulas from the drop-down menu.
Clear the R1C1 reference style check box in the upper-left corner of the Working with Formulas section, then click OK.
The R1C1 reference style check box changes the reference style of row and column headings, as well as cell references, from A1 to R1C1.