title: How to unpivot in BigQuery?
body: <p>Not sure what functions to call, but transpose is the closest thing I can think of.</p>
  
  <p>I have a table in BigQuery that is configured like this:
  <img src="https://i.stack.imgur.com/lleEU.png" alt="enter image description here"></p>
  
  <p>but I want to query a table that is configured like this:</p>
  
  <p><img src="https://i.stack.imgur.com/5ZgWe.png" alt="enter image description here"></p>
  
  <p>What does the SQL code look like for creating this table?</p>
  
  <p>Thanks!</p>