Tranposing an array of cells

hi there

Looking to take an array of cells and paste them from left to right as right to left.

for example if I have 3,2,4 and want them to be 4,2,3.

The paste special option will make them vertical and then horizontally but not how I am expecting them to be.

Hello PickSlides,

Just a few questions:
Are you looking for a worksheet formula or VBA to do this?
Will the range to be transposed be a single row?

Worksheet formula would be preffered.

Yes, it is a single row.

I used the "Record macro" to perform this, I'm sure there's gotta be an easier way to do it. See attachment for the example, simply input values/data on the 1st input sheet and hit "run" button, result will then pop on the 3rd sheet.
Hope it helps. Thanks.

Sub All()
'
' All Macro
'
' Keyboard Shortcut: Ctrl+Shift+A
'
Range("A1:C1").Select
Selection.Copy
Sheets("Transpose").Select
Range("B1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Range("A1").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "1"
Range("A2").Select
ActiveCell.FormulaR1C1 = "2"
Range("A3").Select
ActiveCell.FormulaR1C1 = "3"
Columns("A:A").Select
ActiveWorkbook.Worksheets("Transpose").Sort.SortFields.Clear
ActiveWorkbook.Worksheets("Transpose").Sort.SortFields.Add Key:=Range("A1"), _
SortOn:=xlSortOnValues, Order:=xlDescending, DataOption:=xlSortNormal
With ActiveWorkbook.Worksheets("Transpose").Sort
.SetRange Range("A1:B3")
.Header = xlGuess
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
Range("B1:B3").Select
Selection.Copy
Sheets("Output").Select
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
End Sub

Worksheet formula would be preffered.

The method you should opt for would I think depend largely on the initial range and whether or not it is always a fixed size etc... if it is only ever A1:C1 as outlined then to get Ouput!A1:C1 to display Input!C1:A1

Output!A1:
=INDEX(Input!$A$1:$C$1,4-COLUMNS($A1:A1))
copied to C1

Thank you both.