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 answers

Face recognition after photo transformation?

Z-edge 27" monitor fixed stand tilting forward

Bios problem

Discover these free and legal streaming services

How to convert tzone to degrees celsius?

Lost cable lock code

No "export" button in gimp

Icon overlay icon inlay

Lost information

Install a gps tracker