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.

Punchlinern
  • 2,498
  • 1
  • 23
  • 34
Frank
  • 9
  • 1
  • 2

1 Answers1

2

Yes, use TRANSPOSE(array_or_range) (documentation).

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

Punchlinern
  • 2,498
  • 1
  • 23
  • 34