how to transpose forumlas

[iturnrocks]

If this is possible, please let me know

Example: I would like to copy cells B1-B3 and Transpose them to D1-F1
without the formulas updating.

A B C D E F G
1 124 =A1 =A1 =A2 =A3
2 275 =A2
3 806 =A3

As I am typing this I am thinking if I format B1-B3 as text then
transpose then format to number, this might work. If anyone knows a
quicker way i would appreciate it. Thank you.

 

[Dave Peterson]

I'd select C1:C3
edit|replace
what: =
with: $$$$$=
replace all

edit|copy
edit|paste special|transpose (into d1:F1)

Select c1:c3 and D1:F1
edit|replace
what: $$$$$=
with: =
replace all

You make the formulas text, then do the copy|paste special, then make the text
back to formulas.

 

[RagDyer]

Reading between the lines, do either of these help:

=INDEX($A:$A,COLUMNS($A:A))
=INDEX($B:$B,COLUMNS($A:A))
=INDEX($C:$C,COLUMNS($A:A))
?
And copy across columns as needed.

 

[iturnrocks]

Thanks, both of those methods worked. The second suggestion is what I
was looking for, although the first may help me with another problem I
have had in the past.

Thank you

 

[RagDyeR]

Appreciate the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

in message
Thanks, both of those methods worked. The second suggestion is what I
was looking for, although the first may help me with another problem I
have had in the past.

Thank you