title: Transpose columns to rows in BigQuery
body: <p>For BigQuery, How can I transpose columns 'Ds Hrc Shm', 'Ds Orc Cwp' ... into rows
  and also transpose rows inside 'sku' into columns and keep the value inside to be the same</p>
  <p>FROM</p>
  <pre><code>   SKU     | Ds Hrc Shm  | Ds Orc Cwp  | Ds Orc Mwp  
  DB-MIX-HTS        1             1              1
  DB-ORC-TUS        0             1              1
  </code></pre>
  <p>INTO</p>
  <pre><code>          DB-MIX-HTS | DB-ORC-TUS 
  Ds Hrc Shm      1           0
  Ds Orc Cwp      1           1
  Ds Orc Mwp      1           1
    
  </code></pre>
  <p>Should I use pivot / unvipot or any simple way to do?</p>
  <p>I try to use pivot but I cannot declare a column header inside IN</p>
  <pre><code>SELECT *
  FROM
  (
  SELECT `manual_input.sku_translations`.`ds_hrc_shm` AS `ds_hrc_shm`, 
  `manual_input.sku_translations`.`sku` AS `sku_1`,
   FROM `manual_input.sku_translations`
   ) 
   PIVOT
  (
   SUM(`ds_hrc_shm`) FOR `sku_1` IN (['DB-ORC-TWS'], ['DB-MIX-SGT'])
   ) 
  </code></pre>
  <p><a href="https://i.stack.imgur.com/rkwTj.png" rel="nofollow noreferrer">Here's the sample of data</a></p>