How to repeat a cell value to n times in google sheets

Assuming you have data in Column A, a list of products and you want to repeat them in the next column or in another sheet to n times. Let’s assume you want to repeat them three times. Let’s see the below example How to repeat a cell value to n times in Google Sheets

repeat cell value to n times in google sheets

Formula:

=ARRAYFORMULA(TRIM(TRANSPOSE(SPLIT(QUERY(
 REPT(A2:A6&",", 3), ,999^99), ","))))

Formula Tip

Change the n times by changing the value ‘3’ in the formula.

For example, if you want to repeat the cell value to ‘5‘ times then simply change ‘3’ to ‘5′

How to repeat a cell value to n times in google sheets

Read More:

COMMENTS