Tip: How To Use The Index Function To Transpose Data In Numbers

May 6th, 2008 | by Michael |

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!

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.

Numbers Templates