Column spacing

[IanK1515]

Hello.

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.

[#2 · Accepted solution]

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

[#3]

@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.

[#4]

@Haytham Amairah 

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