How to pivot dataset?

I use Spark 2.1.

I have some data in a Spark Dataframe, which looks like below:

**ID** **type** **val** 
  1       t1       v1      
  1       t11      v11
  2       t2       v2     

I want to pivot up this data using either spark Scala (preferably) or Spark SQL so that final output should look like below:

**ID**   **t1**   **t11**   **t2**
  1        v1       v11
  2                            v2