数据：Ms sql server
有一个表：
name type area sen min fee
a in bj,a 50 20 20
a in bj,b 60 10 5
a out bj,a 30 15 15
a out bj,b 40 25 25
b in gz,a 15 13 13
b in gz,b 12 6 6
b out gz,b 5 5 5
b in tj,a 3 3 3
b in tj,a 23 13 13
b out tj,a 33 21 21
---------------------------------------------------
如何才能让dbgrid这样显示？如果不成要怎么才能实现？
name type area sen in_min out_min income payout
a in bj 110 30 25
a out bj 70 40 40
b in gz 27 19 19
b out gz 5 5 5
b in tj 3 26 16 16
b out tj 33 21 21
----------------------------------------------------
要怎么写才能实现上边的显示？