reflecting values in a column into a row

[MikeB]

I am creating a chart to map a round-robin chess game. If there are 4
players, then all 4 has to play one another.

if I have the names

John
Mike
Sally
Bill

Then I'd like to type them into a columns and write a formula in a
row to pick up the names

the spreadsheet should then look like this:

John Mike Sally Bill
John
Mike
Sally
Bill

I think it may be achieved with the Indirect() function, but my Excel
2007 help seems broken and I can't figure it out without an example.

Thanks.
MikeB

 

[Gord Dibben]

With names in A2:A5

Enter in B1 =INDIRECT("A"&COLUMN(B1))

Or =INDIRECT("A"&COLUMN(A1)+1)

Copy across to E1 to get this...................

John Mike Sally Bill
John
Mike
Sally
Bill


Gord Dibben MS Excel MVP