link from rows to columns

[Guest]

I have a series of values in sheet 1 going down from A1 to A10. I would like
to link these values in sheet 2, but going from A1 to J1.

The transponse function is only good for "special paste values" and the
"paste link" function only pastes the information with the same format as
sheet1.

Any suggestions?
Thanks,
Jonathan R

 

[Dave Peterson]

You could try this:

Copy|paste special|paste link
(but in an out of the way location)

Then select those cells
edit|replace
what: =
with: $$$$$= (some unique string)
replace all.

Now those formulas are strings

Copy|paste special|transpose

select the range
edit|replace
what: $$$$$= (same string)
with: =
replace all

And clean up that out of the way helper range.