行作为列名称分组的行

I have a query which I need to transpose the rows returned into separate columns, but I need the column names returned from the row values, and another field as the value under these columns.I have a query which I need to transpose the ro