Pleaseeeeeeeee Help me
i am having one table where i have roomno as column.In rows i get
x,x,x,1
y,y,y,2
where x,x,x are some others columns and 1 is romm no 1
and
where y,y,y are some others columns and 2 is romm no 2.
I want
1 2
x,x,x x,x,x,
is it possible
if yes then please lete me know how