Canada debt on the sheet "Debt" will be transposed in C7 and euro zone debt in C12. I prefer to have the loop run through the data set (5 worksheets) and copy and transpose into my upload sheet (Statatest).

I hope this is clear. Thanks again.