I use sql analyzer from Microsoft....

here is what I need help with


Loan number....................Call type
123456................................120
123456................................118


I need a way to show this


Loan Number......Type1......Type2
1233456..............120..........118


How ?