Move various colums into one column but leaving a blank row in between

Asked Apr 07 '16 at 12:30

Active Apr 07 '16 at 12:39

Viewed 61 times

Can anybody help with the following, I have various columns with different amounts of rows in each and would like all info moved to one column only.

I have found the following How to Consolidate Data from Multiple Excel Columns All into One Column which works perfectly, but need it to add a blank cell after each column moved. Is this possible?

Thanks!!!

edited Jul 09 '18 at 18:41

Community

asked Apr 07 '16 at 12:30

Frank Mosquera

Where do you need the blank cell added? – MikeC Apr 08 '16 at 00:09
Hi, thanks for helping out. I would like a blank cell added after each of the columns is moved to the first column. – Frank Mosquera Apr 11 '16 at 12:03

0 Answers0