WebMD Health interview question

Converting rows to columns using SQL