Repeat whole row N times based on column value in Google Sheets

Give a try on below formula-

=INDEX(SPLIT(FLATTEN(SPLIT(JOIN("",INDEX(REPT(BYROW(A2:D3,LAMBDA(x,TEXTJOIN("|",0,x)))&"@",E2:E3))),"@")),"|"))

enter image description here

To make it dynamic spill array, use-

=INDEX(SPLIT(FLATTEN(SPLIT(JOIN("",INDEX(REPT(BYROW(A2:INDEX(D2:D,MATCH("zzz",D2:D)),LAMBDA(x,TEXTJOIN("|",0,x)))&"@",E2:INDEX(E2:E,MATCH(9^9,E2:E))))),"@")),"|"))

enter image description here

Related Contents:

  1. Repeat each row N times in Google Sheets
  2. ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
  3. Conditional formatting based on another cell’s value
  4. Google Sheets importXML Returns Empty Value
  5. Get the last non-empty cell in a column in Google Sheets
  6. How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
  7. How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
  8. Query is ignoring string (non numeric) value
  9. What factors determine the memory used in lambda functions?
  10. ArrayFormula and “AND” Formula in Google Sheets
  11. How to SUM duration in Google Sheets?
  12. I get Formula parse error with all formulas
  13. IMPORTXML and right XPath from Bloomberg price [duplicate]
  14. How to list all permutations without repetition?
  15. How to use arrayformula with formulas that do not seem to support arrayformulas?
  16. How to create all possible pair combinations without duplicates in Google Sheets?
  17. ARRAY_LITERAL, an Array Literal was missing values for one or more rows
  18. Is there a way to evaluate a formula that is stored in a cell?
  19. Import data into Google Colaboratory
  20. Apps Script: how to get hyperlink from a cell where there is no formula
  21. Download link for Google Spreadsheets CSV export – with Multiple Sheets
  22. No permission to call msgBox in Google Apps Scripting
  23. Generate all possible combinations for Columns(cross join or Cartesian product)
  24. How to compare dates or date against today with query on google sheets?
  25. Periodically refresh IMPORTXML() spreadsheet function
  26. Conditional Formatting from another sheet
  27. How do I add formulas to Google Sheets using Google Apps Script?
  28. How to Autofill last row with formula, when data is received from IFTTT on the last row?
  29. Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
  30. Google Sheet yields infinitesimal number as remainder of an integer/whole number
  31. Google Sheets Formula for Extracting Domain From Website?
  32. Stacking multiple columns on to one?
  33. New Google Spreadsheets publish limitation
  34. New Google spreadsheet Concatenate limit 50000 characters
  35. Difference between two dates expressed as years, months, days (in one column)
  36. Google Sheet use Importxml error could not fetch url [duplicate]
  37. How to maintain absolute cell address even when deleting ranges?
  38. Moving google apps script to v8 file upload stopped working from sidebar
  39. ultimate short custom number formatting – K, M, B, T, etc., Q, D, Googol
  40. Google Spreadsheet SCRIPT Check if edited cell is in a specific range
  41. Generate a repeating sequence based on vector
  42. How to define global variable in Google Apps Script
  43. Accessing Google Spreadsheets with C# using Google Data API
  44. How to auto select range from a filter without having to manually enter it?
  45. Can no longer produce PDF from Google Sheets spreadsheet for some of the users
  46. How to copy a row from one google spreadsheet to another google spreadsheet using google apps script?
  47. Google Sheets API returns “The caller does not have permission” when using server key
  48. Matlab: repeat every column sequentially n times [duplicate]
  49. Synchronize independent spreadsheet rows, filled by IMPORTRANGE()
  50. google script detect empty cell after edit or delete

Leave a Comment