Tip: learn how to Use The Index operate To Transpose data In Numbers

I simply found this nice Numbers tip on Fury&Frost.com: you need to use the INDEX() perform to transpose information to every other table. learn the post for a full rationalization, but use the next function to get the results shown in the reveal shot above: =INDEX(Prefs::$A$1:$E$15,COLUMN(),ROW()) excellent one!

extra: persisted right here

Leave a Reply