Fill Down In Rows But Want to Increase By Letter

K

Karl

Hi I want to fill down by rows say c3,c4,c5 so on but want it to fill by
letter. Example I want c3 to be c4 c4 to be d4 c5 to be e4 with the 4
staying constant but go up by letter going down a row. Hope this makes sense.
The c4,d4,e4,are results from another sheet. Thanks Karl
 
M

Max

Sounds like you want a dynamic transpose to Sheet1's C4:IV4 ..

In Sheet2,

Put in the starting cell, ie in C3:
=INDEX(Sheet1!$C$4:$IV$4,,ROW(A1))

Copy C3 down as far as required
(maximum copy down is to C256)
 
Top