BlackBearDude
Programmer
I need to take a table such as:
casenum type fee
222 elec 50.00
222 bldg 25.00
333 dway 75.00
333 elec 50.00
444 bldg 25.00
and turn it into:
casenum bldgfee elecfee dwayfee
222 25.00 50.00 0.00
333 25.00 0.00 75.00
444 25.00 0.00 0.00
I am feeling like a real idiot by not being able to come up with the solution, and I know it's going to be obvious.
Appreciate any help you guys & gals can provide.
Thanks
Patrick
casenum type fee
222 elec 50.00
222 bldg 25.00
333 dway 75.00
333 elec 50.00
444 bldg 25.00
and turn it into:
casenum bldgfee elecfee dwayfee
222 25.00 50.00 0.00
333 25.00 0.00 75.00
444 25.00 0.00 0.00
I am feeling like a real idiot by not being able to come up with the solution, and I know it's going to be obvious.
Appreciate any help you guys & gals can provide.
Thanks
Patrick