Write some software

I need you to develop some software for me. I would like this software to be developed for Mac using SQL. Using sqlpro, need a script to transpose columns into rows. Current table structure: Part, Loc, W1, W2, W3 PartA, Atlanta, 10,20,10 PartB, Dallas, 5,10,20 Desired table structure: Part, Loc, Week, Qty PartA, Atlanta, W1, 10 PartA, Atlanta, W2, 20 PartA, Atlanta, W3, 10 PartB, Dallas, W1, 5 PartB, Dallas, W2, 10 PartB, Dallas, W3, 20 Number of parts, location, weeks will change so can’t be hard coded Thanks.