Convert multiple rows and columns to one colu
Solved/Closed
rahimisoft
venkat1926
- Posts
- 6
- Registration date
- Sunday October 31, 2010
- Status
- Member
- Last seen
- March 28, 2011
venkat1926
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Related:
- Convert row to column in notepad++
- Notepad++ transpose row to column - Best answers
- How to convert multiple rows to single row in notepad++ ✓ - Forum - Excel
- Converting rows data into columns on conditon ✓ - Forum - Excel
- How to copy the Column value into Rows ✓ - Forum - Excel
- How to convert rows to columns in notepad++ ✓ - Forum - Excel
- How to repeat multiple rows in excel - Guide
5 replies
venkat1926
Oct 31, 2010 at 10:08 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Oct 31, 2010 at 10:08 PM
the data is from row 1 down to row 8(it can have as many rows) and three columns(it can have as many columns).
macro "test" is operative macro
macro "undo" undoes the result of the macro
try this macro
macro "test" is operative macro
macro "undo" undoes the result of the macro
try this macro
Sub test() Dim j As Long, k As Long, r As Range, dest As Range j = Range("A1").End(xlToRight).Column For k = 1 To j Set r = Range(Cells(1, k), Cells(1, k).End(xlDown)) r.Copy Set dest = Cells(Rows.Count, "A").End(xlUp).Offset(3, 0) dest.PasteSpecial Next k End Sub
Sub undo() Dim r As Range Set r = Range("a1").End(xlDown).Offset(1, 0) Set r = Range(r, Cells(Rows.Count, "A").End(xlUp)) r.EntireRow.Delete End Sub
venkat1926
Jan 14, 2011 at 06:47 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Jan 14, 2011 at 06:47 PM
copy column by column into destination pooint
Didn't find the answer you are looking for?
Ask a question
venkat1926
Dec 14, 2011 at 10:49 PM
- Posts
- 1864
- Registration date
- Sunday June 14, 2009
- Status
- Contributor
- Last seen
- August 7, 2021
Dec 14, 2011 at 10:49 PM
djuMSze
will you please open a new thread and give complete information and problem
thanks
will you please open a new thread and give complete information and problem
thanks