title: How to reshape/recast data in Excel from wide- to long-format
body: <p>I want to reshape my data in Excel, which is currently in "wide" format into "long" format. You can see each variable (<code>Column Name</code>) corresponds to a tenure, race and cost burden. I want to more easily put these data into a pivot table, but I'm not sure how to do this. Any ideas out there?</p>
  
  <p>FYI, the data are HUD CHAS (Department of Housing and Urban Development, Comprehensive Housing Affordability Strategy), which has over 20 tables that would need to be reshaped.</p>
  
  <p><a href="https://i.stack.imgur.com/H5080.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/H5080.png" alt="Image of codebook for data"></a></p>
  
  <p><a href="https://i.stack.imgur.com/vgCWu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vgCWu.png" alt="Image of data itself"></a></p>