Row mirror image

[2000m2]

Hello,

I am trying to get the mirror image of a row of data.
Let's say I have data in cells A1, B1, C1, D1, etc. and I want to change this to D1, C1, B1, A1.
Is there a function that can do this?

Thanks!

[DonkeyOte]

You could do the following:

E1: =INDEX($A1:$D1,5-COLUMNS($E1:E1))
copied to H1

Is that what you want ?

[2000m2]

that looks like it will work, thanks!