maybe selfexplanation, but... we do not list any example in that case. :-(
Really easy issue to resolve: http://opengrok.libreoffice.org/xref/help/source/text/scalc/01/04060107.xhp
Example can be based on any of the other examples in the same file.
I'm just about done with this.
Created attachment 128288 [details]
Two screenshots related with transpose
If you're looking for input from the design team you could CC the ux-advice mailing list; only skilldesign (that I was searching for) is not effective.
My two cents anyway: It took me a while to figure out what it means. Typically I transpose per paste special dialog and expect row and col exchanged. The image looks like a 5x3 matrix transposed to 3x5 and I couldn't follow. The reason to my misunderstanding is obviously that you add column headers (A...D) and row titles (1..x). If you mark those per grey background it is much easier to understand.
Regarding design I would make the columns a little bit wider, perhaps squared or use text. And an example with before/after with the formula at the connector is perfect, IMHO. Feel free to use or modify what I attached.
Regarding the text it is not necessary to have a range selected, at least this part is unclear and wouldn't be helpful for me. Most relevant information is to press shift+enter, however. And I wonder how to not lock the range after transposing it. Looks like only via copy/paste special, which could be stated in the help. (And lead to the enhancement request to have this option with the command.)
Joel Madero committed a patch related to this issue.
It has been pushed to "master":
tdf#103397 - added example for Transpose function