• You can use PIVOT function to convert rows into columns. Bt please bear in mind that the reverse is not true.