Convert multiple rows and columns to one colu [Solved/Closed]

Question

Previous Topic Next Topic

Convert multiple rows and columns to one colu [Solved/Closed]

Report

rahimisoft

Posts: 6
Registration date: Sunday October 31, 2010
Status: Member
Last seen: March 28, 2011

- Oct 31, 2010 at 12:50 PM
venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

- Dec 14, 2011 at 10:49 PM

Hello,

I have some data in excel sheet. Here is the example.
480,000 600,000 720,000
520,000 650,000 780,000
300,000 375,000 450,000
432,000 540,000 648,000
260,000 325,000 390,000
304,000 380,000 456,000
340,000 425,000 510,000
304,000 380,000 456,000

and must convert to
480,000
520,000
300,000
432,000
260,000
304,000
340,000
304,000

600,000
650,000
375,000
540,000
325,000
380,000
425,000
380,000

720,000
780,000
450,000
648,000
390,000
456,000
510,000
456,000

thanks alot

Convert multiple rows and columns to one colu
Notepad++ convert row to column ✓ - Forum - Excel
How to convert rows into columns in notepad++ ✓ - Forum - Excel
How to copy the Column value into Rows ✓ - Forum - Excel
Repeat multiple rows in excel - How-To - Excel
How to convert multiple jpg to pdf mac - How-To - MacOS

5 replies

Answer 2 / 5

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
Jan 14, 2011 at 06:47 PM

copy column by column into destination pooint

Answer 3 / 5

djuMSze
Jan 14, 2011 at 01:36 AM

How do you that without using macro? I am not really familiar with macro.

Answer 4 / 5

Murali
Dec 14, 2011 at 10:41 PM

Hi

Thanks a lot

Answer 5 / 5

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
Dec 14, 2011 at 10:49 PM

djuMSze

will you please open a new thread and give complete information and problem
thanks

Ask a question

venkat1926 · Accepted Answer · 2010-10-31T22:08:03-0400

Answer 1 / 5

venkat1926

Posts: 1862
Registration date: Sunday June 14, 2009
Status: Contributor
Last seen: July 30, 2015

797
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

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

Convert multiple rows and columns to one colu [Solved/Closed]

5 replies

Your reply

Subscribe To Our Newsletter!