How to invert or rotate a table?

[Karl]

I am trying to manipulate the date in a table by inverting and rotating into
various orientations. How can I do this in Excel without hard coding the
formulas into each cell?

 

[Marcelo]

hi,

did you try to copy and paste special transpose?

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Karl" escreveu:

 

[Karl]

Thanks,

This will do row to column transpose and is a partial solution but how do I
get a flip or mirror image on either a vertical or horizontal axis?

 

[Stephen]

I don't think this is possible without either a macro or hard-coded formulas
(which you seem to be against, for some reason).