| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help using Transpose | Excel Discussion (Misc queries) | |||
| Want to Transpose | Excel Discussion (Misc queries) | |||
| I WANT TO TRANSPOSE LINKS, AS WE TRANSPOSE VALUES | Excel Worksheet Functions | |||
| transpose a column into many rows | Excel Discussion (Misc queries) | |||
| TRANSPOSE() | Excel Worksheet Functions | |||
Linear Mode
