select column value as a header and other column value inside that header

See more:

SQL

I have data in below form

|User | Question           |    Answer     |
------------------------------------
|ra12 |what is your role? |    manager     |
|ra12 |What you like to be| Product Owner  |
|bas2 |what is your role? |    SMO         |
|bas2 |What you like to be| Project Manager  |

.
.
.

I need it in this form using sql query.

|User | what is your role?|What you like to be|
------------------------------------------------
|ra12 | manager           | Product Owner     |
|bas1 | SMO               | Project Manger    |

can anybody help me in this query. table name is tbl_survey.

Thank you in advance.