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.
View best response
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
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.
after a few tries, it worked. Thank you very much. you saved me a lot of time.