Hi Steven

With the entries to be transposed in row1, starting in A1, enter the
following formula in A2 and copy across as far as required
=INDEX(1:1,COUNTA(1:1)-COLUMN(A1)+1)

--
Regards
Roger Govier

"Steven" wrote in message
...
I have a list that I want to transpose from right to left (not to be
confused with transposing a horizontal selcetion to vertical)
any quick and easy solution?