How do I make the auto fill handle to input data from left to righ

[Jason]

My data is currently stored vertically. January Total is in column A, Feb is
in B, March is in C, etc... I want to convert it so that Jan Total is in row
1, Feb in 2, March in 3, etc...

Instead of dragging each month from it's current column to be in vertical
order, I would like to use the fill handle to automatically grab the data in
the next column. However, when I attempt to do this, it automatically grabs
the data in the row below since I am dragging the fill handle to the next
row. Is there any way for me to get the fill handle to grab the data in the
next column when I drag it to the next row?

 

[Jim Thomlinson]

What you are asking for is not supported. Perhaps you could copy the range
and Paste Special -> Transpose to reorg your data.

 

[Jason]

That worked. Thanks!

What you are asking for is not supported. Perhaps you could copy the range
and Paste Special -> Transpose to reorg your data.