title: Normalize (reformat) cross-tab data for Tableau without using Excel
body: <p>Tableau generally works best when <a href="http://kb.tableausoftware.com/articles/knowledgebase/denormalize-data" rel="noreferrer">input data is in "normalized" format</a>, rather than cross-tab. This is also referred to as converting from "wide format" to "long format".</p>
  
  <p>That is, converting from:</p>
  
  <p><img src="https://i.stack.imgur.com/0ig36.png" alt="enter image description here"></p>
  
  <p>To:</p>
  
  <p><img src="https://i.stack.imgur.com/gc7sk.png" alt="enter image description here"></p>
  
  <p>Tableau provides a <a href="http://kb.tableausoftware.com/articles/knowledgebase/addin-reshaping-data-excel" rel="noreferrer">"reshaping tool" for Excel users</a>, but if you don't have Excel, you're stuck.</p>
  
  <p>So how can you get a spreadsheet into this format, without using Excel?</p>