title: Transposing columns and using column names as values in another row
body: <p>I have a table like this: </p>
  
  <pre><code>BatchNo     | Replication | Bioreactor | Centrifuge | Red | Amber | Green 
  ------------|-------------|------------|------------|-----|-------|-------
  A1-1        | 1           | 1          | 1          | 1   | 0     | 0     
  A1-2        | 0           | 0          | 0          | 0   | 0     | 1     
  A1-3        | 1           | 0          | 1          | 0   | 1     | 0     
  </code></pre>
  
  <p>Steps I need to take:
  Make a new column Stage containing the columns- Replication, Bioreactor, Centrifuge etc as categories and transposing their values to populate a column status. Then populate another column RAG based on the occurrence of a value in either Red, Amber or Green fields. </p>
  
  <pre><code>BatchNo | Stage       | Status | RAG 
  --------|-------------|--------|------
  A1-1    | Replication | 1      | Red 
  A1-1    | Bioreactor  | 1      | Red 
  A1-1    | Centrifuge  | 1      | Red 
  </code></pre>
  
  <p>Any ideas how to approach this? Do I need to do 2 tranpositions? Cheers</p>