Want to Transpose

P

PaulW

This is probably a silly question... but how can I transpose some cells?

The cells I want to transpose are forumla's, so copy and pasting them
doesn't help.

Quite often I find myself making several comparisons of lists against
themselves, while theres probably an easier method I haven't got that far
yet, and usually end up needing to change something from Horizontal to
Verticle.
At the moment I have to manually enter all the cell references which is
tedious.

Eg.
I have various numbers along the top of the spreadsheet, starting at E1,
these come from Sheet2 where they are calculated.
I then want A5 to be the same as E1
I want A6 to be the same as F1
I want A7 to be the same as G1, etc
 
D

Dave Peterson

One way...

Select your range to transpose
edit|replace
what: = (equal sign)
with: $$$$$
replace all

Now all your formulas are text.

Do the copy|paste special|transpose. The text "formulas" don't change--since
they're text.

Now select the range and
edit|replace
what: $$$$$
with: =
replace all

(And do the same to the original range, too.)
 
Top