Does this help:

=INDEX($A:$A,COLUMNS($A:A))

And drag across.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

wrote in message
oups.com...
Hello,

I need to tranpose a long list of text values that I have running from
A1:A400 into A1 - XX#

When I try to paste special it tells me that the cells are not the same
width.

Is there any way around this?