Sub Macro4()
Range("A1").Select
Range(Selection, Selection.End(xlDown)).Copy
Range("B1").PasteSpecial Paste:=xlAll, Operation:=xlNone, SkipBlanks:=False _
, Transpose:=True
Columns("A:A").ClearContents
ActiveWorkbook.SaveAs Filename:= _
"C:\\testzz.csv", FileFormat:=xlCSV, _
CreateBackup:=False
End Sub