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

by

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

More 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 to SUM duration in Google Sheets?
  8. ArrayFormula and “AND” Formula in Google Sheets
  9. ARRAY_LITERAL, an Array Literal was missing values for one or more rows
  10. Query is ignoring string (non numeric) value
  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. How to create all possible pair combinations without duplicates in Google Sheets?
  17. Col BY causing parse error in Google sheets query
  18. Count cells that contain any text
  19. How to make a range repeat n-times in Google SpreadSheet
  20. In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
  21. How to create a runing total formula that expands automatically when new rows are added to my spreadsheet [duplicate]
  22. No permission to call msgBox in Google Apps Scripting
  23. Periodically refresh IMPORTXML() spreadsheet function
  24. Selecting the last value of a column
  25. Download link for Google Spreadsheets CSV export – with Multiple Sheets
  26. Stacking multiple columns on to one?
  27. New Google spreadsheet Concatenate limit 50000 characters
  28. TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
  29. Google Sheet API v4
  30. How to create INDIRECT array string of multiple sheet references in Google Sheets?

Leave a Comment