Need help spacing very large column
I have a large colomn of values(approx 3000). I need to insert 11 clear cells in between each value to match a timeline in another column. How can I add 11 cells in between eatch value without having to do it manually?
Posted Mar 20, 2019, 8:16 PM UTC
Maybe try creating a new column, set the first to =A1 or whatever the top value is, skip 11 lines, =A2, then copy the series down
Once that's done copy and paste special>values then delete the original column
Will try it out. Thank you very much
Still having some issues. Excel wants to add 10's to the = ; so if i out in =a1 all the way through =a8 then try and copy down the column, the next formula is =a18, and then =a28