Change/Reverse the table

[0-0 Wai Wai ^-^]

Hi.
There's the table:
A1 A2
B1 B2
C1 C2

1)
I would like to make the table upside-down, ie:
C1 C2
B1 B2
A1 A2
How to do?

2)
This time I would like to mirror my table , ie:
A2 A1
B2 B1
C2 C1
How to do?

--
Additional information:
- I'm using Office XP
- I'm using Windows XP

[Ian]

Do you mean permanently, or to be able to toggle between them?

--
Ian
--
"0-0 Wai Wai ^-^" <x@x.com> wrote in message
news:O9gEcQy%23FHA.740@TK2MSFTNGP12.phx.gbl...
>
> Hi.
> There's the table:
> A1 A2
> B1 B2
> C1 C2
>
> 1)
> I would like to make the table upside-down, ie:
> C1 C2
> B1 B2
> A1 A2
> How to do?
>
> 2)
> This time I would like to mirror my table , ie:
> A2 A1
> B2 B1
> C2 C1
> How to do?
>
> --
> Additional information:
> - I'm using Office XP
> - I'm using Windows XP
>
>
>

[0-0 Wai Wai ^-^]

"Ian" <me@me.com> 秎ン news:U5Alf.20428$7p5.7720@newsfe4-win.ntli.net い级糶
....
> Do you mean permanently, or to be able to toggle between them?
Permanently.
But if I can toggle between them, I would like to know too.

[Ian]

I assume this isn't your real data which would be really simple.

1) Create a helper column after your data and number it 1,2,3 etc. Select
the data and go to Data>Sort using this new column to Sort by. Sort
ascending or descending depending on the order you want.

2) Create a helper row below your current data and sort using this row. When
you go to Data>Sort select Options and click Sort left to right.

If you need to have both row and column helpers in place at the same time,
make sure that where to row and column coincide you use the higher of the 2
numbers.

So your data would look something like this

A1 A2 1
B1 B2 2
C1 C2 3
1 2 4
--
Ian
--
"0-0 Wai Wai ^-^" <x@x.com> wrote in message
news:Ovxe0pz%23FHA.3104@TK2MSFTNGP15.phx.gbl...
>
>
> "Ian" <me@me.com> 秎ン news:U5Alf.20428$7p5.7720@newsfe4-win.ntli.net
> い级糶
> ...
>> Do you mean permanently, or to be able to toggle between them?
> Permanently.
> But if I can toggle between them, I would like to know too.
>
>

[0-0 Wai Wai ^-^]

WoW! A clever way of using "sort" :D
Thanks a lot.

"Ian" <me@me.com> 秎ン news:VAClf.17132$GC1.14061@newsfe6-gui.ntli.net い级糶
....
> I assume this isn't your real data which would be really simple.
>
> 1) Create a helper column after your data and number it 1,2,3 etc. Select
> the data and go to Data>Sort using this new column to Sort by. Sort
> ascending or descending depending on the order you want.
>
> 2) Create a helper row below your current data and sort using this row. When
> you go to Data>Sort select Options and click Sort left to right.
>
> If you need to have both row and column helpers in place at the same time,
> make sure that where to row and column coincide you use the higher of the 2
> numbers.
>
> So your data would look something like this
>
> A1 A2 1
> B1 B2 2
> C1 C2 3
> 1 2 4
> --
> Ian
> --
> "0-0 Wai Wai ^-^" <x@x.com> wrote in message
> news:Ovxe0pz%23FHA.3104@TK2MSFTNGP15.phx.gbl...
> >
> >
> > "Ian" <me@me.com> 秎ン news:U5Alf.20428$7p5.7720@newsfe4-win.ntli.net
> > い级糶
> > ...
> >> Do you mean permanently, or to be able to toggle between them?
> > Permanently.
> > But if I can toggle between them, I would like to know too.
> >
> >
>
>

[Ian]

Glad to help. Thanks for the feedback.

--
Ian
--
"0-0 Wai Wai ^-^" <x@x.com> wrote in message
news:uR5%23d9z%23FHA.1336@TK2MSFTNGP10.phx.gbl...
>
> WoW! A clever way of using "sort" :D
> Thanks a lot.
>
> "Ian" <me@me.com> 秎ン news:VAClf.17132$GC1.14061@newsfe6-gui.ntli.net
> い级糶
> ...
>> I assume this isn't your real data which would be really simple.
>>
>> 1) Create a helper column after your data and number it 1,2,3 etc. Select
>> the data and go to Data>Sort using this new column to Sort by. Sort
>> ascending or descending depending on the order you want.
>>
>> 2) Create a helper row below your current data and sort using this row.
>> When
>> you go to Data>Sort select Options and click Sort left to right.
>>
>> If you need to have both row and column helpers in place at the same
>> time,
>> make sure that where to row and column coincide you use the higher of the
>> 2
>> numbers.
>>
>> So your data would look something like this
>>
>> A1 A2 1
>> B1 B2 2
>> C1 C2 3
>> 1 2 4
>> --
>> Ian
>> --
>> "0-0 Wai Wai ^-^" <x@x.com> wrote in message
>> news:Ovxe0pz%23FHA.3104@TK2MSFTNGP15.phx.gbl...
>> >
>> >
>> > "Ian" <me@me.com> 秎ン news:U5Alf.20428$7p5.7720@newsfe4-win.ntli.net
>> > い级糶
>> > ...
>> >> Do you mean permanently, or to be able to toggle between them?
>> > Permanently.
>> > But if I can toggle between them, I would like to know too.
>> >
>> >
>>
>>
>
>