I've been struggling with this for a while now, in that I cannot find a query that allows for a pivot of one column without a second reference/ID column to pivot on. 

My current table looks as depicted:

```
Y1M1 Y1M2  Y1M3   Y1M4   Y1M5
-----------------------------
0    NULL  NULL   NULL   NULL
125  NULL  NULL   NULL   NULL
250  NULL  NULL   NULL   NULL
500  NULL  NULL   NULL   NULL
750  NULL  NULL   NULL   NULL

```

When I would like to pivot to something similar to:

```
Y1M1  Y1M2  Y1M3  Y1M4  Y1M5
-----------------------------
0     125   250   500   750

```

Due in part to the complexity of a pivot statement and part a surprising lack of guides about one-column pivoting the closest query I've written is 

```
SELECT *
FROM 
  (SELECT [Y1M1]
   FROM @Result) AS SourceTable
PIVOT
  (MAX([Y1M1])
  FOR [Y1M1]
  IN ([Y1M2],[Y1M3],[Y1Q1],[Y1M4],[Y1M5])) AS PivotTable

```

However, this query returns all NULL values and I cannot add the [Y1M1] column to the IN clause without throwing an error on execution. Likewise, variations of the query using UNPIVOT also have proved difficult to run successfully.

Any advice regarding PIVOT queries would be appreciated