title: Show the column header to a row if there is value in cells of that columns without VBA
body: <p>Update 1:</p>
  
  <p>Because my question is not clear, so I post second example</p>
  
  <p><img src="https://i.stack.imgur.com/s0unH.png" alt="Example 2"></p>
  
  <p>Because row 2, there is value 1 at Item 04 so the Get Item Name = Item 04. It is random and have a large number of columns (500).</p>
  
  <p>The problem:</p>
  
  <p>I would like to have a way to get a column header if there is any value input to the cells under that header.  Please note that if at row 2 and column 1 has value, then other cell of row 2 will not have any value (other than 0).</p>
  
  <p>It is hard to explain the problem in words so I have created an example. </p>
  
  <p><img src="https://i.stack.imgur.com/5Vw0i.png" alt="Sample"></p>