i have a table with columns
region,type,qid,Ano,creator,reviewer,reviewerdate,revstatus
Data looks like
central,aaa,100,111,abc,abd,2/10/2010,initial
central,aaa,100,111,abc,hjk,2/14.2010,pending
east,bbb,292,112,khk,abj,2/11/2010,pending
central,kkl,103,111,kkl,klh,2/10/2010,initial
output should be
Central
aaa
100 111 abc abd initial pending
2/10/2010 2/14/2010
kkl
103 111 kld kfh initial
2/10/2010
east
bbb
202 112 khk abj pending
2/11/2010
can anyone suggest how i make the data in multiple rows for different status with date for same qid and ano can be brought as above?