Transpose text and formatting

[amgbg]

How do I solve it using TRANSPOSE to transpose original text and formatting.

Using regular TRANSPOSE {=TRANSPOSE($Utg.A11:A25)} only transposes plain text. And I need a change in formatting in the original cell to be changed in transposed cell as well.

[Zizi64]

You can not reference to the manual (direct) format properties of the cells.
And you can not reference the various formating properties what you have applied inside one cell.

You can try apply cell styles by formulas or by the conditional formatting feature (for example with a helper table containing the style-codes in a transposed array...).

And you can use the real sub- and supercript characters of the Unicode table, instead of the direct formatted sub-, supercript characters - if your problem related to that format properties.

[Zizi64]

Here is a simple example:

Transposed Style array.ods

(11.51 KiB) Downloaded 116 times