change the column into row

Question

i have join two tables by create a store procedure. after getting answer. Meanwhile,i convert my column into row.how can i change this???????????