Flipping EXCEL columns! Transposing vertically - getting it the

I normally get data from 01/12/09 to 31/12/09. I copy this data down to other spreadsheets. My data source has changed tack and is giving me data starting at the end of the month at the top and with the beginning of the month at the bottom. I know that the transpose button on paste special will take this data and give it to me one one row. Is there any paste special type device that can allow to paste in vertical reverse. ie. paste what was at the bottom on the top??