How to Reverse the entire row content ?

[raju.r.083]

Hi all,

Hope all is good.

Can anyone please help me in getting a solution for the below mentioned problem ?

I have certain data and is as shown in the sheet "Data". It doesn't have any reference where I can sort it out (like smallest to largest or vice versa).
My requirement is that, The entire row content must be shown in an upside manner (i.e. the last row content must be at the top and top row content must be at the bottom).
Please see the sheet "Required one" for my required solution. (I have done this manually).

But actually, this has thousands of rows in it. I have just shown some 100 rows in this for my explanation.

Can anyone please help me out in getting a formula on how to reverse the row order ?

Thank you all for your time and for the solution.

[D.Lovell]

In D4 and copied down....

Please Login or Register  to view this content.

Will get the person reference, then the other columns can easily be done from that with normal table lookups.

[Glenn Kennedy]

...or in A2, copied across and down:

=INDEX(Data!A$2:A$106,ROWS($1:$106)-ROWS($1:1))

[D.Lovell]

Here I did the whole thing for you...

These 3 are the same lookup, matching again the person in column D and then returning data from columns 1,2 & 3.....

A2 and copied down.....

Please Login or Register  to view this content.

B2 and copied down.....

Please Login or Register  to view this content.

C2 and copied down.....

Please Login or Register  to view this content.

This is the one that is actually reversing the order of the list....

D2 and copied down....

Please Login or Register  to view this content.

Since there are no duplications in this column it makes sense to start here, and then use that as the lookup reference for the other columns.

Your example is attached with this is place.

[raju.r.083]

Hi Lovell & Glenn,

Really appreciate your quick response and that too with a perfect solution.
Your solutions are working excellently as per my requirement.

Thank you once again for your time and for the solution. And I am really sorry for my late response.