transpose

[Steven]

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?

 

[Roger Govier]

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)

 

[June7]

Looks like my first attempt to post reply to this post lost which is good
because it was bad! What is your list in? Cells on a worksheet, text file,
database, query?

 

[Steven]

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






-הר××” טקסט מצוטט-

Thanks