Reset a Vertical and/or Horizontal Column

[Boblink]

Hi.

I have Office 2021 and would like to reset a Vertical and/or a Horizontal Column of numbers.

The only option that I see is to reset them A-Z or Z-A or in numerical order.

I want to reset the top number to the bottom and the bottom number to the top and not reset the string of  column in numerical in assenting or descending order.

Thank you for your help.

Bob

[#2]

@Boblink 

=INDEX($C$1:$C$28,ROW($A$28)-(ROW(A1)-ROW($A$1)))

In my Excel 2013 sheet this formula returns the intended result if i correctly understand what you are looking for.