Usenet.com

www.Usenet.com

Group Index

Comp Thread Archive from Usenet.com

<-- __Chronological__ --> <-- __Thread__ -->

Transpose a column of formulas in Excel



I'm using Excel 2000.  I have a column (precisely, a 1-column by
12-row range) containing formulas.  I want to end up with a transposed
copy of this range (12 columns by 1 row) in which each cell contains
exactly the same formula as the corresponding cell of the source
range.

For a simple example, suppose range H7:H18 contains these formulas:

H7  =E7+G7
H8  =E8+G8
etc.

I want to copy this range into C44:N44 so that I end up with

C44  =E7+G7
C45  =E8+G8
etc.

Is there an easy, direct way to do that?  If not, is there an indirect
way, short of brute force, and how does it work?

Thanks in advance.

--Erv



<-- __Chronological__ --> <-- __Thread__ -->


Usenet.com



Please check out one of the premium Usenet Newsgroup Service Providers below for access to Usenet.