title: Transpose DataFrame Without Aggregation in Spark with scala
body: <p>I looked number different solutions online, but count not find what I am trying to achine. 
  Please help me on this. </p>
  
  <p>I am using Apache Spark 2.1.0 with Scala. Below is my dataframe:</p>
  
  <pre><code>
  +-----------+-------+
  |COLUMN_NAME| VALUE |
  +-----------+-------+
  |col1       | val1  |
  |col2       | val2  |
  |col3       | val3  |
  |col4       | val4  |
  |col5       | val5  |
  +-----------+-------+
  </code></pre>
  
  <p>I want this to be transpose to, as below:</p>
  
  <pre><code>
  +-----+-------+-----+------+-----+
  |col1 | col2  |col3 | col4 |col5 |
  +-----+-------+-----+------+-----+
  |val1 | val2  |val3 | val4 |val5 |
  +-----+-------+-----+------+-----+
  </code></pre>