OFFSET?

[JTL9161]

I have a list of 155 names going down a list. I need to copy each name to another table but instead of up and down I need to going left to right

(SHEET1) C2 value goes to (SHEET2) C5
(SHEET1) C3 value goes to (SHEET2) D5
(SHEET1) C4 value goes to (SHEET2) E5
(SHEET1) C5 value goes to (SHEET2) F5

and so on.

Thank you,
James

 

[Dan_W]

In Cell C5 on Sheet 2, if you write:

=TRANSPOSE(Sheet1!C2:C157)

it should work.

 

[Dan_W]

Sheet 1:

Sheet 2:

 

[JTL9161]

Perfect! Thanks.