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