Hi Scottsman78,

Can anyone tell me if there is a way of copying a series of rows of
cells in excel and pasting them as a whole to a series of columns?
I don't know if this can be done?

After the copy, select Edit, paste special and check the "transpose"
box.

Regards,

Jan Karel Pieterse
Excel MVP
http://www.jkp-ads.com