Rows to columns headers

I have data in a table where I need to move one column to become the column headers (in this case designation)   Userid designation value A Firstname Peter A Lastname ...