UNPIVOT

UNPIVOT enables you to see columns as rows in a query result.

In our sales pipeline we have both the create date and the close date for each deal. If we run the following query:

SELECT created_date,
       close_date,
       product,
       close_value
      FROM sales_pipeline
     WHERE deal_stage = "Won"

We would get back a table whose first several rows looked like this:

By modifying this query with an UNPIVOT we could create a timeline for all the deals with when they were created and closed:

WITH B AS (
    SELECT account, opportunity_id, created_date, close_date
      FROM sales_pipeline
     WHERE deal_stage = "Won"
)
SELECT *
  FROM B
UNPIVOT ( date FOR date_type IN (created_date AS 'CREATED', close_date AS 'CLOSED') )
 ORDER BY account, opportunity_id, date