Forum Discussion
Column spacing
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.
Hi IanK1515,
I know an easy trick to do that and it's demonstrated in this https://1drv.ms/v/s!ArtU2vr1IWYYgbY5x4fVeUfTxVx0Dg.
But you need to copy the numbers below 11 times instead of 3.
Hope that helps
3 Replies
Hi IanK1515,
I know an easy trick to do that and it's demonstrated in this https://1drv.ms/v/s!ArtU2vr1IWYYgbY5x4fVeUfTxVx0Dg.
But you need to copy the numbers below 11 times instead of 3.
Hope that helps
after a few tries, it worked. Thank you very much. you saved me a lot of time.
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.
