Transpose relative cell references
 

Suppose I have, say, a COLUMN of data (A1:A10) in a spreadsheet and I want to
create a relative link to another spreadsheet to ROWS A1:J1.

What's the best way to do this?

Many thanks for your help.