Copy columns but pasting them in new sizes

[RorschachDK]

Hello all

My problem is that i want to copy certain columns but when im pasting them i want to add a blank cell after each filled cell. The column then becomes twice the length with each second cell being empty.
How is this done ?

Best regards

[excelVBAmaster.com]

If your data is in column A and you want to paste to column B, a formula based solution would be to enter this in B1 and copy it down:

Please Login or Register  to view this content.

If you would rather do it using VBA, use:

Please Login or Register  to view this content.

Why not let me do it
Upload your file at www.excelVBAmaster.com

[RorschachDK]

Thanks for the reply..i canīt get to work though. Could you describe more thorough how to implement the formula based solution?

Best Regards

[excelVBAmaster.com]

Sure!

If your data is in column A,
Copy my formula above and paste it into B1.
Copy B1 and Paste in the rest of Column B.

You will notice that B2 is blank, but B3 is not.
You will have to paste it for twice the count you have in Column A though (If you have 10 rows in A you need to paste the formula From B1 to B20)

Copy Column B and Paste Values (ALT+hvv)