the transpose option does show when I rightclick special paste
 

I have been creating spreadsheets of addresses from the web. I have used
copy and special paste function and clicked on the transpose box, but for
some reason when I try to repeat this process when I right click on 'special
paste' no longer see the transpose box. I am using Excel 2003. If anyone
can help I would really appreciate it.
Thanks