Make multiple columns into a single column
Closed
shilpa
-
Nov 16, 2011 at 05:41 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 16, 2011 at 07:08 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 16, 2011 at 07:08 AM
Related:
- Make multiple columns into a single column
- Tweetdeck larger columns - Guide
- Display two columns in data validation list but return only one - Guide
- How to make multiple selections in photoshop - Guide
- Allow multiple downloads chrome - Guide
- How to delete multiple files on mac - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 16, 2011 at 07:08 AM
Nov 16, 2011 at 07:08 AM
obviously your version is 2007 or above because in 2003 or earlier the total number of columns is only 256
anyhow try this macro
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
