Column spacing

New Contributor


I have a very long column(3000 cells) of values.  I need to place 11 blank cells between each value.  I am trying to be able to do this without manually copying and inserting 11 spaces over three thousand times.

3 Replies

Hi @IanK1515,


I know an easy trick to do that and it's demonstrated in this video.

But you need to copy the numbers below 11 times instead of 3.


Hope that helps

@Haytham Amairah 

Thank you.  Will I have to continue 1-11 down the entire length of the coloumn past the 3000 values? I attempted to go 1-11, eleven times down the b column and then sort, but it did not space out.

@Haytham Amairah 

after  a few tries, it worked.  Thank you very much.  you saved me a lot of time.