Excel Formula: Pull formula Horizontally, change Column

[chloec]

Hello. Thanks in advance for help. I am trying to transpose data using formulas.
I want to fill the formula to the right and down.

For example: =INDEX($B$2:$B$12,COLUMNS($C:D))

When I pull formula to the right, it works great.
When I pull it down, I would like to change formula to this:
=INDEX($C$2:$C$12,COLUMNS($C:D))
=INDEX($D$2:$D$12,COLUMNS($C:D))
=INDEX($E$2:$E$12,COLUMNS($C:D))

 

[Deepak]

Hi,

Something like as...

=OFFSET($B$2,COLUMNS($C:D),ROWS($2:2))

 

[Deepak]

This might also do the same task.

=INDEX($B$2:$E$12,COLUMNS($C:D),ROW($1:1))

Moreover, Pls share the sample file with manual calculation as well.