Referencing a horizontal range into a vertical range

[The Grim Discovery]

Hello

Is there a shortcut to referencing a horizontal range into a vertical range (and vice versa) without having to manually go into each cell and change the formula?

This is what I've got:
In Sheet 1 the data resides in the column H2:H141
In Sheet 2 I need to reference that data in row G2:EQ2

I've got three cells into this:

In Sheet 2 cell G2 is the formula =Sheet1!H2
In Sheet 2 cell H2 is the formula =Sheet!H3
In Sheet 2 cell I2 is the formula =Sheet1!H4
But I'm having to manually change the formula. I really want to be lazy and not make this minor adjustment to the remaining 100+ cells.

Please tell me there's a way.
Thanks in advance.

 

[FormR]

Hi, you can try in G2 copied across.

=INDEX('Sheet1'!$H$2:$H$141,COLUMNS($G2:G2))

Or a single formula that will spill across.

=TOROW('Sheet1'!H2:H141)

 

[RoryA]

Or =TRANSPOSE(H2:H141)

 

[The Grim Discovery]

That's brilliant. Thanks both of you. Appreciated.