Transposing column data to rows on a new sheet 1

[MrBubbles]

I am new to this forumn and apologize if I am posting this question incorrectly...

I have a Excel loan amortization table (out of box template supplied with Excel) that has interest payments indicated in a column. G18 is the interest for March 06, G19 is the interest for April 06, etc.

On a separate sheet, I have a financial pro-form that has the months in columns... March is column C, April is column D, etc. I want C25(current sheet)= G18 (from the amortization table), D25 = G19, E25 = G20, etc.

How do I copy/paste/transpose this data?

Thank you!

 

[CautionMP]

Try looking at the TRANSPOSE worksheet function. The help file is not clear. Here is a hint on usage.

Select cells C25:E25, in the formula bar type =TRANSPOSE(G18:G20) then hit CTRL+SHIFT+ENTER.

If this does what you want, notice that the formula in cells C25:E25 will have changed to {=TRANSPOSE(G18:G20)}

Hope this helps,
CMP

Instant programmer, just add coffee.

 

[MrBubbles]

Thank you - you have just answered a question that has plauged me for YEARS of developing financial pro-formas!

Thank you!