|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
For a simple example, suppose range H7:H18 contains these formulas:
I want to copy this range into C44:N44 so that I end up with
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.