Post your code and lets have a look at it. Hard to give you a good response
without seeng the code...

"Karaman" wrote:

Jim,
Thank you for the reply. I am familiar with what you recommended, however
the transpose function places the data in one column while I wish to preserve
the data order. I already have the macro to place the data in the proper
order and position for the first row. The only piece that is missing is how
to switch and repeat the same copy and paste process for the next row of data
with over 1000 rows of data. I hope you can help.

"Jim Thomlinson" wrote:

This might be a silly question but why not use

PasteSpecial - Transpose ???

This should save you a lot of grief.

"Karaman" wrote:

I created a macro to convert data from rows to columns, but I need the
command to insert in the Do Loop in order to repeat the same process for the
next row(s). The data is available in each row where the first four cells
are a title followed by 48 cells with data in each 4 cells for a month. The
mothly data needs to be converted to column form. This was done easily in a
macro, but how do I repeat the same process fore the next row(s)?