How to make a range repeat n-times in Google SpreadSheet

by

I would use split() function instead of arrayformula() and rept() function to repeat cell positions. For example, if your n=4 the formula will look like this:

=split(rept(C1&";",4),";")

rept() repeats cell position C1+semicolon four times creating a string and split() function divides created string by semicolons to horizontal cells.

You can rotate resulted horizontal table to vertical table using transpose() function:

=transpose(split(rept(C1&";",4),";"))

And yes, you can use it to create dynamic formulas with help of arrayformula() function:

=arrayformula(count(D:D)*split(rept(C1&";",4), ";"))

More Related Contents:

  1. ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
  2. Conditional formatting based on another cell’s value
  3. Google Sheets importXML Returns Empty Value
  4. Get the last non-empty cell in a column in Google Sheets
  5. How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
  6. How to SUM duration in Google Sheets?
  7. ArrayFormula and “AND” Formula in Google Sheets
  8. ARRAY_LITERAL, an Array Literal was missing values for one or more rows
  9. Query is ignoring string (non numeric) value
  10. Repeat whole row N times based on column value in Google Sheets
  11. I get Formula parse error with all formulas
  12. IMPORTXML and right XPath from Bloomberg price [duplicate]
  13. What factors determine the memory used in lambda functions?
  14. How to list all permutations without repetition?
  15. How to use arrayformula with formulas that do not seem to support arrayformulas?
  16. Repeat each row N times in Google Sheets
  17. How to create all possible pair combinations without duplicates in Google Sheets?
  18. Col BY causing parse error in Google sheets query
  19. Count cells that contain any text
  20. In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
  21. QUERY and order by the first date of column
  22. Import data into Google Colaboratory
  23. Apps Script: how to get hyperlink from a cell where there is no formula
  24. How to Autofill last row with formula, when data is received from IFTTT on the last row?
  25. How to compare dates or date against today with query on google sheets?
  26. Download link for Google Spreadsheets CSV export – with Multiple Sheets
  27. Stacking multiple columns on to one?
  28. New Google spreadsheet Concatenate limit 50000 characters
  29. Google Sheet use Importxml error could not fetch url [duplicate]
  30. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]

Leave a Comment