Invert and transpose a range

[cesna123]

Hello,
I have a named source range.
How can I transpose it and inverte it in one formula?

Please check the picture attached, it shows the desired result to get (target range).
thanks

[Mordred]

Try this, I haven't been able to test it but mayhap it will work

Please Login or Register  to view this content.

[cesna123]

Try this, I haven't been able to test it but mayhap it will work

Please Login or Register  to view this content.

Hello, thanks a lot, but i want it to be an excel formula.
I should not use vba...
thanks a lot

[Mordred]

I thought that because you posted in the programming thread that you wanted VBA.

[DonkeyOte]

The ranges are virtually indecipherable in your image - always better to post a file if you want help with a file - however if we assume that top left cell of result matrix is E12 then:

E12:
=INDEX(SR,COLUMNS($E12:E12),ROWS(E$12:E12))
applied to E12:G13