Try the below formula and copy that to right cells as required.

=INDEX($A$1:$J$1,,COLUMNS($A$1:$J$1)-COLUMN(A$1)+1)

If this post helps click Yes
---------------
Jacob Skaria


"PL" wrote:

I have a row of data that I would like to reverse the order, how do I do so?

Eg

A B C

I want C B A

Thank you