I wish to copy a complete column of data and paste it into another column. However with one stipulation. I wish to place the data from each copied cell automatically (with a macro) into every third cell of the new column.

Also I wish to automate the insertion of a new row at regular intervals over an entire column range.