Sub a()
Dim i&
With ActiveSheet.UsedRange.Value = .UsedRange.Value: End With
For i = 3 To 8 Step 2
Range(Cells(1, i), Cells(Rows.Count, i).End(3)).Resize(, 2).Cut _
Cells(Rows.Count, 1).Resize(, 2).End(3)(2)
Next
Range(Cells(1, 1), Cells(Rows.Count, 1).End(3)).SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Range("A1").CurrentRegion.Sort Key1:=[A1], Order1:=xlAscending
End Sub