Transpose, but preserve, a range of formulas?

Giganews Newsgroups
Subject: Transpose, but preserve, a range of formulas?
Posted by:  Erv Young (ervyou…@nc.rr.com)
Date: 22 Oct 2003

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

Replies