revert table

[agenda9533]

Is it possible to revert excel table - to revert rows in columns and columns
in rows.
Example,
A 2 3 4
B
C
REVERTS to
A B C
2
2
4

Thank you!

[swatsp0p]

copy/paste special>Transpose will do what you ask.

HTH

[alMandragor]

mark the area;
right-click;
click "Pase Special";
mark "Transpose";
click ok

"agenda9533" wrote:

> Is it possible to revert excel table - to revert rows in columns and columns
> in rows.
> Example,
> A 2 3 4
> B
> C
> REVERTS to
> A B C
> 2
> 2
> 4
>
> Thank you!

[alMandragor]

ups.. forgot something:

mark the area;
CTRL + C (copy it);
right-click where you want it reverted;
click "Paste Special";
mark "Transpose";
click ok


"alMandragor" wrote:

> mark the area;
> right-click;
> click "Pase Special";
> mark "Transpose";
> click ok
>
> "agenda9533" wrote:
>
> > Is it possible to revert excel table - to revert rows in columns and columns
> > in rows.
> > Example,
> > A 2 3 4
> > B
> > C
> > REVERTS to
> > A B C
> > 2
> > 2
> > 4
> >
> > Thank you!