Before doing the copy, paste special, transpose, could you sort the original dataset so that it is in reverse order?

Say your original data is in A1:100. Add a sequence of numbers in B1:B100 that run from 1 to 100. (This is easy - enter 1 in B1, 2 in B2, highlight B1:B2 and double click the little square in the lower right corner of B2.)

Now, highlight A1:B100 and use Data Sort to sort by column B, Descending.

Now do the original trick. Highlight A1:A100, Copy, move to D2 and Paste Special, Transpose.

Finally, go back, resort A1:B100 by column B, Ascending, erase the values in B and you are all set.