Thread: Copying formulas in Columns and transpose to rows?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
  
Posts: 2,836
Default Copying formulas in Columns and transpose to rows?
Copy Paste Special Values Transpose

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"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?



Reply With QuoteReply With Quote