r/googlesheets•
mlsmith45

Using Indirect() with Transpose()

Unsolved

I'm trying to use Indirect inside a Transpose function and I'm getting a parsing error.

=TRANSPOSE('570 1 questions'!INDIRECT(I2))

I'm trying to reference the I2 cell which has a range in it (E12:E16). I want to transpose the data from that range in another sheet.

Is this possible?

Posted Apr 9, 2025, 8:32 PM UTC

11
Loading comments…