title: Unpivot Data with Multiple Columns - Syntax Help Please
body: <p>I have the following data in which I would like to unpivot</p>
  
  <p><img src="https://i.stack.imgur.com/LD5Xa.png" alt="enter image description here"></p>
  
  <p>I created this query to unpivot the 'Actual' rows but can't seem to figure out the syntax for unpivoting the 'Plan' and 'PriorYear' as well.</p>
  
  <pre><code>SELECT FiscalYear, Period, MetricName, ActualValue
  FROM vw_ExecSummary
  UNPIVOT
  (ActualValue FOR MetricName IN ( [Net Revenue], [Total C.S. Salaries]
  )) AS unpvt  
  WHERE [Type] = 'Actual'
  </code></pre>
  
  <p>The unpivoted data looks like this but I want to also add the Plan and PriorYear columns to the right of the ActualValue column below</p>
  
  <p><img src="https://i.stack.imgur.com/9l3hX.png" alt="enter image description here"></p>
  
  <p>Any help would be greatly appreciated.   Thanks.</p>