Turn the data upside down

[Gizmo]

Hi guys,

I'm wondering if there is an easy way to put upside down the data that is
not arranged in an ascending/descending order, for exemple:

intitial situation is:
A
1 Apple
2 Orange
3 Banana
4 Strawberry
5 Peach

and what I would like to make is to get this:

A
1 Peach
2 Strawberry
3 Banana
4 Orange
5 Apple

Naturally, in this case it's easy to get it done manually, but with large
data it becomes more complicated...
Thanks a lot for any ideas...

Gizmo

 

[Nitin Harkawat]

how about sorting it by col A that holds the serial number in descending
order

 

[Gizmo]

Yes, sure, didn't thought about it...
Thanks Nitin,
Rgds