Paste transose every 250 observations of a column

[eac13]

Hi guys,
I have a column with 250 observations for one stock, then in the same column i have 250 observations for another stock and so on.
i want to change this format. i want to have in each row all the observations for one stock.
this can be done by copy paste transpose the 250 observations each time.

so for the first stock, i copy paste transpose the first 250 observations of column A into the row B1
for the second stock i copy paste transpose the next 250 observations of column A into the row B2 and so on.

The problem is i have 1000 stocks.

Can i automate this process via a macro? Any help will be very much appreciated.

[daffodil11]

I got this to work with 5 groups of 10. This assumes there are no breaks between the groups.

Please Login or Register  to view this content.

[Trebor76]

Hi eac13,

Try this:

Please Login or Register  to view this content.

Regards,

Robert

[eac13]

Thank you both so much!! i really appreciate your help! you saved me! i wish you every happiness and success in your life! thank you again!

[Trebor76]

Thank you both so much!! i really appreciate your help! you saved me! i wish you every happiness and success in your life! thank you again!

You're welcome

If you could mark the thread as solved it would be appreciated.

Regards,

Robert