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