Transpose, but preserve, a range of formulas?

[Erv Young]

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

 

[Ken Wright]

Do you really need a copy of the formulas, or will a linked range do. Both are possible, but the
linked range is slightly quicker:-

With your data in say A1:A5, select say C1:G1 and type =TRANSPOSE(A1:A5) and then array enter it
using CTRL+SHIFT+ENTER at the same time.

Other way is to select your range of formulas in A1:A5, do Edit / replace and replace = with %%.
Then copy the range A1:A5 and Edit / Paste Special / Transpose wherevere you want. then select
your new tranposed range and do Edit / Replace replacing %% with =.

 

[Erv Young]

With your data in say A1:A5, select say C1:G1 and type =TRANSPOSE(A1:A5) and then array enter it
using CTRL+SHIFT+ENTER at the same time.

Other way is to select your range of formulas in A1:A5, do Edit / replace and replace = with %%.
Then copy the range A1:A5 and Edit / Paste Special / Transpose wherevere you want. then select
your new tranposed range and do Edit / Replace replacing %% with =.

That does it very nicely. Thanks, Ken. I had given up on Transpose()
because I didn't know about Ctrl-Shift-Enter. I think I had been a
bit obtuse about the Edit/Replace; replacing the = with _something_
makes it a lot easier to fix back up than it is if you replace it with
nothing. Mmm, yes, I remember that now.

--Erv

 

[Ken Wright]

LOL - I know the feeling - Drives me nuts when I know I've done it before, but just can't find it.
Anyway, glad you are sorted now, and appreciate the feedback.