how to transpose forumlas
 

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.


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570522

how to transpose forumlas
 

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.

iturnrocks wrote:

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.

--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570522

--

Dave Peterson

how to transpose forumlas
 

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.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"iturnrocks" wrote
in message ...

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.


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile:
http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570522

how to transpose forumlas
 

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


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile: http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570522

how to transpose forumlas
 

Appreciate the feed-back.
--

Regards,

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

"iturnrocks" wrote
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


--
iturnrocks
------------------------------------------------------------------------
iturnrocks's Profile:
http://www.excelforum.com/member.php...o&userid=37246
View this thread: http://www.excelforum.com/showthread...hreadid=570522