Can someone explain for me how with the help of formula I can solve this issue? We have an input range of Tags (letters and numbers). Whole massive must be duplicated in the same order n times. The formula should work with column D-D, not with range D1-D6 because number of input values can be changed.

The idea is that the amount of elements in the input column can variate.

  • Welcome. Please add a brief description of your search/research efforts as is suggested on How to Ask.
    – Rubén
    Sep 4 '19 at 16:35
  • 1
    Possible duplicate of Repeat range under each other in Google Spreadsheets
    – Rubén
    Sep 4 '19 at 16:49
  • Both variants are not good, in script and formula u need to specify range, not column ((
    – Mykyta
    Sep 4 '19 at 17:20
  • Please edit your question to include that as part of your continuous search/research efforts.
    – Rubén
    Sep 4 '19 at 17:25

Maybe the easier way to get the expected result is by using Copy & Paste

  1. Select the range to be copied (D2:D7)
  2. Copy
  3. Select the destination range (F2:F31)
  4. Paste

If your still prefer to use a formula, the following one will return the required values but not the formatting:


To apply the formatting, you could use conditional formatting


If you need to use "D:D" instead of D2:D7, replace it by


Use the use of D2 as the start cell instead of D because the column include a header and it should not be included.


COUNTA will work for TEXT values. For NUMBERS use COUNT and if you have mixed value types use LEN(D2:D)>0;


  • I'm posting this in case that the possible duplicate be hard to follow as the accepted answer suggest the use of a custom function (script) and the answer that provides a formula doesn't include any explanation about how it works.
    – Rubén
    Sep 4 '19 at 17:20
  • now its working with numbers, but giving only ,,,,, in case of tags like LBA24
    – Mykyta
    Sep 4 '19 at 17:41
  • @Mykyta I'm sorry, there was a typo (replace COUNT by COUNTA)
    – Rubén
    Sep 4 '19 at 17:45
  • already, now works perfect thank you a lot
    – Mykyta
    Sep 4 '19 at 17:48
  • @Mykyta Glad to know. Please accept the answer (click on the tick mark below the answer score / voting arrows)
    – Rubén
    Sep 4 '19 at 17:49

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.