PDA

View Full Version : Repeating List With Blank/Zero Values



Instigator
2016-09-14, 02:36 AM
Okay, so I have the following list of names


John


Josh


Randy





Bryan


Luke





Paul









How do I repeat this list in another column (where I can drag the formula down so that the list repeats for "n" number of times) so that it ignores all of the blank spaces and repeats only the cells that are not equal to zero/blank.

Example of what I am trying to accomplish in the table below



John


Josh


Randy


Bryan


Luke


Paul


John


Josh


Randy


Bryan


Luke


Paul


John


Josh


Randy


Bryan


Luke


Paul



I have been able to successfully repeat the list but it includes the blank spaces as part of the list of names to repeat.

Azumi
2016-09-14, 04:58 AM
Hope this works, Iam using array formula


cheers
Azumi

Instigator
2016-09-16, 01:27 AM
Azumi,

Thank you for your work. It was highly effective and extremely useful.


Very Respectfully,
Instigator

KenDue
2016-09-16, 05:01 PM
No formula is necessary to accomplish this. Copy the group of names, including blank rows, and paste into the desired column. Select the first blank cell, press CTL and select the remaining blank cells. Right-click and choose "Delete", then select "Move Cells Up". Highlight the group of names and copy down as many times as desired using the grab box.