这种行转列查询可以兑现么

这种行转列查询可以实现么?
zgbh          rq        bcbh bcmc
000001     2012-10-11 001 白班                          
000001     2012-10-12 001 白班                          
000001     2012-10-13 001 白班                          
000001     2012-10-14 001 白班                          
000001     2012-10-15 001 白班                          
000001     2012-10-16 001 白班                          
000001     2012-10-17 001 白班                          
000001     2012-10-18 001 白班                          
000001     2012-10-19 001 白班                          
000001     2012-10-20 001 白班                          
000001     2012-10-21 001 白班                          
000001     2012-10-22 001 白班                          
000001     2012-10-23 001 白班                          
000001     2012-10-24 001 白班                          
000001     2012-10-25 001 白班                          
000001     2012-10-26 001 白班                          
000001     2012-10-27 001 夜班                          
000001     2012-10-28 001 夜班                          
000001     2012-10-29 001 夜班