Sub Macro1()
Dim nb_col As Long, col As Long
nb_col = UBound(ActiveSheet.UsedRange.Value, 2)
Range("B1:B" & Range("B65535").End(xlUp).Row).Select
Application.CutCopyMode = False
Selection.Cut
Range("A" & Range("A65535").End(xlUp).Row).Select
Cells(ActiveCell.Row + 1, 1).Select
ActiveSheet.Paste
For col = 3 To nb_col
Columns(col).Select
Selection.Cut
Cells(1, col - 1).Select
ActiveSheet.Paste
Next col
Range("A1").Select
End Sub