Special Paste: Reverse Order in Column

Question

Hello,

The operation I want to perform in Excel is as follows:

The data (original) that I need to change the order of is entered in such a way that the first value is in A10 (for example) and the last one is in A1.
My task is to reverse this order: That is, to make sure that the first one (formerly in A10) is now in A1 and the last one at the bottom.
I must not modify the original data but go through a copy and paste.

Thank you for your help

Configuration: Windows 7 / Internet Explorer 8.0

Bruce Willix · Answer

What I would do is transpose the values twice using a special paste (the transposition "turns" your data 90°)  -- Sword of Omens, give me Sight beyond Sight...

Mike-31 · Answer

Hello,

Try it like this on the first line of value

=$A$10-ROW()+1

you increment it over the height of your data
then if you want to fix the values, do a Copy/Paste Special Values on the formula range to turn the formulas into values

A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Mike-31 · Answer

Re,

fortunately, this discussion fascinates the participants, it is also possible to use the RANK function on the first line

=RANK(A1;$A$1:$A$10)

and increment downwards

--
A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Mike-31 · Answer

Re,

to bring up the discussion, with an indeterminate range in column A starting from A1 with non-contiguous values

=INDIRECT("A"&NBVAL(A1:$A$20))

A+
Mike-31

A period of failure is a perfect time to sow the seeds of knowledge.

Raymond PENTIER · Answer

Yes, dear friend Mike-31, your formulas are quite interesting, except I think this is a school assignment, and the teacher has set some conditions since John wrote "I must not modify the original data, but go through a copy-paste"! But either the teacher didn’t check the feasibility of his exercise before submitting it to the students, or he is really good and has developed a trick, a magician's manipulation or a sequence of special successive copy-pastes according to a secret algorithm...  Best regards. Retirement is great! Especially in the Caribbean... :-) ? Raymond (INSA, AFPA, CF/R)?

Special Paste: Reverse Order in Column

5 réponses

Texture issues in enshrouded

Unable to connect to freebox os

Edit ad on leboncoin for free

Freebox wifi password

Computer tower that won't turn on

Blocked: are my messages still being delivered?

Video intercom inspector

Your computer can't use another display.

Fransat decoder stuck

No headphone jack on samsung lcd tvs