T
Terri
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?
=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?