Copying formulas in Columns and transpose to rows?
You can copy then paste specialtranspose but your cell references must
first be absolute.
=Tally!$D$10
=Tally!$D$11
=Tally!$D$12
Then you copy and transpose.
=Tally!$D$10 =Tally!$D$11 =Tally!$D$12
Or experiment with INDIRECT function.
Assuming your original formulas are in A1:A3
=INDIRECT("A"&COLUMN(A1)) entered in B1 and copied across will do same thing
as copy and transpose.
Gord Dibben MS Excel MVP
On Wed, 2 Dec 2009 14:05:01 -0800, Terri
wrote:
I have a 2007 worksheet that has formulas in a Column:
=Tally!D10
=Tally!D11
=Tally!D12
How do I transpose the formula columns to rows like:
==Tally!D10 =Tally!D11 =Tally!D12
Now when I copy and Paste special (Transpose) is translates like:
==Tally!D10 =Tally!E10 =Tally!F10
Which is not the data I need?
|