Flip Flop

[abacon1960]

I have a set of data listed from AZ2 all the way to AZ556.

EXAMPLE.

1675
4578
5689
1256
4456
5568
etc.

I want to flip the data so the column will now read. This will allow me to align it with the correct dates that are set in stone on the spreadsheet. The dates are set in reverse order of the data I am importing. The dates need to remain as they ARE.

5568
4456
1256
5689
4578
1675

Is this possible?

 

[igold]

Does this do what you want...

Sub Flip()


    Dim fLop, i As Long, r As Long
    
    Application.ScreenUpdating = False
    r = 1
    fLop = Range("AZ2:AZ556")
    For i = 556 To 2 Step -1
        Cells(i, 52) = fLop(r, 1)
        r = r + 1
    Next
    Application.ScreenUpdating = True
    
End Sub

 

[sandy666]

alternative

PowerQuery

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table16"]}[Content],
    #"Reversed Rows" = Table.ReverseRows(Source)
in
    #"Reversed Rows"[/SIZE]

 

[joeu2004]

Enter into BA2 (any parallel column) and copy down through BA556:

=INDEX($AZ$2:$AZ$556, ROWS($AZ$2:$AZ$556)-ROWS($AZ$2:AZ2)+1)

The key thing that makes this work is the relative reference highlighted in red.