transpose column to a range calculate and transpose to new table loop

hi

This must be basic but i'm drawing a blank. i have a table with data that i need to transpose each coumn into a row that calculates the results and then to transpose the results to a new table. also it would be preferable that if the sum of column "n" is "0" the loop sould stop and fill the next columns "n+1..." of the new table with 0's. attatched is a sample of the file.