Re-ordering a Table

[clumpa]

I have a table with a header (row 1) containing names and each column contains data generated elsewhere in the work book.
What I would like to do is create, using formulae, a new version of the table where the order of the header is different and the data under each name is in the same order

A B C
1 2 3
4 5 6
7 8 9
generated table to be

C A B
3 1 2
6 4 5
9 7 8

Should be easy but I have no idea!!

 

[Luke M]

Assuming your original data is in Sheet1!A1:C4, and the new order of headers is a manual input on Sheet2, formula would be:
=HLOOKUP(A$1,Sheet!$A$1:$C$4,ROW(),FALSE)

 

[clumpa]

Assuming your original data is in Sheet1!A1:C4, and the new order of headers is a manual input on Sheet2, formula would be:
=HLOOKUP(A$1,Sheet!$A$1:$C$4,ROW(),FALSE)

Thanks Luke, just what I needed!