I just found this great Numbers tip on Fury&Frost.com:
You can use the INDEX() Function to transpose data to another table.
Read the post for a full explanation, but use the following function to get the results shown in the screen shot above:
=INDEX(Prefs::$A$1:$E$15,COLUMN(),ROW())
Good one!
