C1, copy down:Probably an easy problem
I have column A and B that I want to transfer in column C like this :
In C
A1
B1
A2
B2
A3
B3
etc
Thx
Sub CombineColumnsAandB()
Dim X As Long
For X = 1 To Cells(Rows.Count, "A").End(xlUp).Row
Range("C1").Offset(2 * (X - 1)).Value = Cells(X, "A").Value
Range("C1").Offset(2 * X - 1).Value = Cells(X, "B").Value
Next
End Sub
Macros are easy to install and use. Press ALT+F11 from any worksheet. This will take you into the VB editor. Once there, click Insert/Module on its menu bar. A code window will open when you do this. Copy/Paste the macro code into that window. Here is the code I proposed...I have no idea how to use macro but I guess it's time to give it a try.
Sub CombineColumnsAandB()
Dim X As Long
For X = 1 To Cells(Rows.Count, "A").End(xlUp).Row
Range("C1").Offset(2 * (X - 1)).Value = Cells(X, "A").Value
Range("C1").Offset(2 * X - 1).Value = Cells(X, "B").Value
Next
End Sub
=INDIRECT("A"&ROUNDUP(ROW()/2,0))
=INDIRECT("B"&TRUNC(ROW()/2))