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.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies