Please help me come up with pivot table with these datas

Question : why there are rejected loans with "Excellent" or "Very good" credit score?

- I 10+ years B C D E F H 1 Rejected Loans Amount Re Application Date Loan Title Risk_Score Risk Score Debt-To-Income DTI Bucket 2 743221 2175 2012/12/19 major_pur 850 Excellent 6687.70% High 3 593088 35000 2012/8/13 other 850 Excellent 45.48% High 4 630521 10000 2012/9/19 major_purc 850 Excellent 38.49% High 5 692806 10000 2012/11/9 car 850 Excellent 29.56% High 6 714789 3000 2012/11/27 vacation 850 Excellent 25.18% High 516174 5000 2012/5/20 Lower Rati 850 Excellent 4.98% Low 617261 20000 2012/9/8 Home loan 850 Excellent 1.20% Low 9 670644 8000 2012/10/22 Loan is for 850 Excellent 0.61% Low 10 570352 18500 2012/7/19 bussiness lo 850 Excellent 0.52% Low 11 562025 10000 2012/7/11 car 850 Excellent 0.31% Low 12 167833 25000 2010/10/6 debt_consc 849 Excellent 35.24% High 13 618098 1000 2012/9/9 Hospital ex 849 Excellent 34.33% High 14 521680 35000 2012/5/26 small_busi 849 Excellent 10% Mid 15 564544 6800 2012/7/13 Be my Ow 849 Excellent 9.99% Low 16 25000 2012/8/10 home_imp: 849 Excellent 0.99% Low 17 720216 35000 2012/12/2 debt_consc 848 Excellent 38.25% High 18 696066 1500 2012/11/13 other 848 Excellent 1.34% Low 19 732263 1500 2012/12/11 small_busi: 847 Excellent 106.39% High 20 603427 62000 2012/8/24 home_imp: 847 Excellent 6.34% Low 21 752505 3500 2012/12/28 Home Imp 847 Excellent 4.25% Low 22 690891 25000 2012/11/8 Business 847 Excellent 0.21% Low 23 506648 35000 2012/5/9 debt_consc 846 Excellent 39.23% High 24 699668 25000 2012/11/15 home_imp: 846 Excellent 18.77% Mid Zip Code State 315xx GA 936xx CA 761xx TX 070xx NJ 331xx FL 302xx GA 113xx NY 066xx 750xx TX 079xx NJ 941xx CA 331xx FL 933xx CA 277xx NC 934xx CA 208xx MD 951xx CA 331xx FL 913xx CA 104xx NY 010xx MA 274xx NC 980xx WA K L M Employme Employment Num