"Harlan Grove" wrote
And why would 3 function calls each in 9 cells, so total 27 function
calls,
ever be preferable to one TRANSPOSE call? ..

It's just personal preference, and taken from a pure ease of set-up and
editing angle, nothing more <g. I do find it much easier to enter and edit
a non-array formula. And to be free from having to grapple with selecting a
precise converse destination grid before array-entering TRANSPOSE (this can
be a mite tough if the source grid is quite large).

If the OP's data were static, Edit Paste Special Transpose would be a
better approach than using formulas.

Agreed, no ifs or buts here.
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----