Make multiple columns into a single column

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I have data in excel sheet with 3600 columns and each column has 6 rows.Suppose say Column 'A'...It has 6 rows.I want the Column 'B' data to be placed from 7th row of Column 'A'.I want only column 'A'.Please help me out.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
obviously your version is 2007 or above because in 2003 or earlier the total number of columns is only 256

anyhow try this macro

Sub test()
Dim j As Long, k As Long
For j = 2 To Range("A1").End(xlDown).Row
Range(Cells(j, 1), Cells(j, 1).End(xlDown)).Copy Cells(Rows.Count, "A").End(xlUp).Offset(1, 0)
 Next j

End Sub