Copy Row Data on from one column to another column with spacing in between them? Can this be done?

Question

Hi, curious if there is a way to copy data from one column to another in with spacing?

Long story short, I want to put data in an excel sheet that has no spacing to a sheet in which the destination has spacing in between them.

I don't want to put individual spacing in between every time in between them each time, can I copy the data and have the pasted information have spacing.

Answer 1

Hi,

In range B1:B9, type 1-9.  Copy B1:B9 and paste it in cell B10.  Select A1:B18 and sort the second column in ascending order.  You may now delete the second column.

Answer 2

Here's a VBA solution for the example given:

Private Sub Test()

     Dim cRow As Long

     Dim mRow As Long

     Application.ScreenUpdating = False

     ' Find last used row in column A

     mRow = Range("A" & Rows.Count).End(xlUp).Row

     For cRow = 1 To mRow

             Range("D" & cRow * 2 - 1).Value2 = Range("A" & cRow).Value2

     Next cRow

     Application.ScreenUpdating = True

 End Sub

Answer 3

That did work for me, thanks.

I wish there was a functional way to do this from the toolbar.

Answer 4

You are welcome.  If my reply helped, please mark it as Answer.