How to invert or rotate a table?
 

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?

How to invert or rotate a table?
 

hi,

did you try to copy and paste special transpose?

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



"Karl" escreveu:

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?

How to invert or rotate a table?
 

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?

"Marcelo" wrote:

hi,

did you try to copy and paste special transpose?

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



"Karl" escreveu:

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?

How to invert or rotate a table?
 

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

"Karl" wrote in message
...
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?

"Marcelo" wrote:

hi,

did you try to copy and paste special transpose?

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



"Karl" escreveu:

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?