title: How to get address, Column Name and Row Name of all marked rows in Excel table as rows in new worksheet
body: <p>I need the row/column combinations marked with an '<strong><code>X</code></strong>' in my table to be available as three columns in another sheet.</p>
  
  <p><img src="https://i.stack.imgur.com/vIKQI.jpg" alt="Table 1"></p>
  
  <ul>
  <li>The first column will consist of the <strong>cell address</strong>,  </li>
  <li>the second column will have the <strong>Row Name</strong>, and   </li>
  <li>the third column will have the <strong>Column name</strong> of the marked cells.  </li>
  </ul>
  
  <p><code>VLookUp</code> and <code>Index</code>/<code>Match</code> are not helping. </p>
  
  <p>Expected result:</p>
  
  <p><img src="https://i.stack.imgur.com/gPnnK.jpg" alt="Output"></p>