0

Is there a range function in Google Spreadsheets where I can link the values of SheetA!A1:A10 to SheetB!A1:J1? So basically rotating the values from rows to columns.

0
2

Yes, use TRANSPOSE(array_or_range) (documentation).

So, for example, in A1 write =TRANSPOSE(SheetA!A1:A10).

2
  • ah great, works perfect. thx
    – Frank
    May 11 '14 at 1:44
  • 1
    Great! Please mark it as the correct answer, by pressing the outlined tick next to the question. May 11 '14 at 7:05

Not the answer you're looking for? Browse other questions tagged or ask your own question.