Help with excel putting vertical values on selected space with horizontal orientation

[Kanelonis]

Help with excel putting vertical values on selected space with horizontal orientation

 

[Sancdar]

Perhaps you're looking for the TRANSPOSE function?
MS Excel: TRANSPOSE Function (WS)

 

[Kanelonis]

Perhaps you're looking for the TRANSPOSE function?
MS Excel: TRANSPOSE Function (WS)

Thank you for the reply.
well transpose only puts the values in horizontal line and for example i have 20 vertical values with transpose i put all 20 in horizontal line but i want to
put for example 5x4 cells and fill them with those 20 vertical values.
Can i post a photo from my pc here?