You wrote

It appears (to me, anyway) that the transpose function only transposes values, not formulas.

You are completely right.

That's why I uploaded the file Transpose_CR in #3 above which also works when you have formulas and you mentioned yourself that most of the values in the table are the result of forumlas.