title: Pivot multiple rows (2 columns) into a single row
body: <p>I have a table where it has only 2 columns, the first columns is a name identifier and the second column is a value for this identifier (basically the table acts as default values), below is a screenshot of that table.</p>
  <p><a href="https://i.stack.imgur.com/guSFG.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/guSFG.png" alt="default value table" /></a></p>
  <p>What I want is to convert the table from multiple rows into a single row and the values would be columns with the first column as column name. Example, the current values to be transformed into the below.</p>
  <p><a href="https://i.stack.imgur.com/7SZlT.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/7SZlT.png" alt="expected result" /></a></p>
  <p>I read about the PIVOT operator, however it requires an aggregate function in the pivot clause but I don't think I can use an aggregate function in this case, its just setting row values as column values.
  Is this possible with PIVOT or is there another construct I should use to achieve this?</p>