=ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(QUERY(
REPT(A1:A3&"♠", 5), ,999^99), "♠"))))
=SORT(TRIM(TRANSPOSE(SPLIT(QUERY(ARRAYFORMULA(
REPT(A1:A3&"♠", 5)), ,999^99), "♠"))), 1, 0)
More Related Contents:
- Repeat whole row N times based on column value in Google Sheets
- ArrayFormula of Average on Infinite Truly Dynamic Range in Google Sheets
- Conditional formatting based on another cell’s value
- Google Sheets importXML Returns Empty Value
- Get the last non-empty cell in a column in Google Sheets
- How to stop / freeze / pause volatile RAND / RANDBETWEEN / RANDARRAY?
- How to SUM duration in Google Sheets?
- ArrayFormula and “AND” Formula in Google Sheets
- ARRAY_LITERAL, an Array Literal was missing values for one or more rows
- Query is ignoring string (non numeric) value
- I get Formula parse error with all formulas
- IMPORTXML and right XPath from Bloomberg price [duplicate]
- What factors determine the memory used in lambda functions?
- How to list all permutations without repetition?
- How to use arrayformula with formulas that do not seem to support arrayformulas?
- How to create all possible pair combinations without duplicates in Google Sheets?
- Col BY causing parse error in Google sheets query
- Count cells that contain any text
- How to make a range repeat n-times in Google SpreadSheet
- In ARRAY_LITERAL, an Array Literal was missing values for one or more rows – indirect formula error in google spreadsheet
- How to create a runing total formula that expands automatically when new rows are added to my spreadsheet [duplicate]
- No permission to call msgBox in Google Apps Scripting
- Periodically refresh IMPORTXML() spreadsheet function
- Is there a custom function or script that returns gid of a specific sheet in Google Sheets?
- Selecting the last value of a column
- Using built-in spreadsheet functions in a script
- Difference between two dates expressed as years, months, days (in one column)
- TypeError: Cannot read property ‘getRange’ of null (line 6, file “Code”) in google sheet script [duplicate]
- Google Sheets QUERY Function: Select Columns by Name
- How to maintain absolute cell address even when deleting ranges?