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!
Tags: apple, iwork, numbers, osx, Tips








