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

Open chat
Talentnett Solutions
Hello,

How may I help you today!

Regards,
Umesh Agarwal
Contact - +91 - 7017544508
Email - umesh.agarwal@talentnett.com

Cool Tips and Tricks Directly Delivered in your Inbox. Subscribe to our Newsletter.

You have successfully subscribed to the newsletter

There was an error while trying to send your request. Please try again.

Talentnett will use the information you provide on this form to be in touch with you and to provide updates and marketing.