How to copy down from 2 columns

[Pumperkin]

Hi,

I have data in column D, and data in column E. I want to move this to column F (for printing) so that it runs

D1
E1
D2
E2
D3
E3

Etc.

I can pull the data D1 into F1, and E1 into F2, but when copying down, it does it like so:

D1
E1
D3
E3
D5
E5

Is it possible to have it so that the missing ones are included?

 

[mumps]

Try this macro:

Sub Pumperkin()
    Application.ScreenUpdating = False
    Dim LastRow As Long, rng As Range, x As Long, y As Long: y = 1
    LastRow = Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
    For x = 1 To LastRow
        Cells(y, 6).Resize(2) = WorksheetFunction.Transpose(Cells(x, 4).Resize(, 2))
        y = y + 2
    Next x
    Application.ScreenUpdating = True
End Sub

 

[Pumperkin]

Well thanks so much - after fiddling trying to work out how on earth to use macros, I managed to get it to work. You are a star

 

[mumps]

You are very welcome.

 

[Pumperkin]

Well thanks so much - after fiddling trying to work out how on earth to use macros, I managed to get it to work. You are a star

Hi, Just to follow on from this, I now have data in columns A through to F, that I wish to convert like this:

A1
B1
C1
D1
E1
F1

These are addresses - I have tidied them as much as I can but can't how to modify the previous Macro (and not quite sure if it's the same thing).

Any help gladly received.

 

[mumps]

Can you post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.

 

[Pumperkin]

Can you post a screen shot of what your data looks like? Section B at this link has instructions on how to post a screen shot: https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html Alternately, you could upload a copy of your file to a free site such as www.box.com. or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Include a detailed explanation of what you would like to do referring to specific cells, rows, columns and worksheets. If the workbook contains confidential information, you could replace it with generic data.

Thanks Mumps. I managed to sort it a different way, by indirect reference and copying across

 

[mumps]

Glad it worked out.