# How to create a custom array of an item repeated N times **URL:** \ **Category:** Questions\ **Tags:** arrays, google-sheets\ **Created:** [August 1, 2024, 11:25pm UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050 "2024-08-01T23:25:50Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![CONYNTRA\_SA](https://avatars.discourse-cdn.com/v4/letter/c/8dc957/32.png) [@CONYNTRA\_SA](https://community.make.com/u/CONYNTRA_SA)\ **Post date:** [August 1, 2024, 11:25pm UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050/1 "2024-08-01T23:25:50Z")
I’m currently building an automation where I need an array, that contains arrays that are empty, that needs to repeat N times. I’ll clarify it with an example: variable repetitions = 3 variable array\_content = [" "] expected output: [[" “] , [” “] , [” "] ] I need these for spreadsheets.batchUpdate, to update n number of cells in a same column. So, in values I have to pass an array of arrays with the desired content of the cells, but the number of cells are not consistent. Any help is welcomed ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 1, 2024, 11:37pm UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050/2 "2024-08-01T23:37:37Z")
Welcome to the Make community! Yes that certainly can be done, but did you know Google Sheets now already has a batch create and batch update rows module? ---
**Author:** ![CONYNTRA\_SA](https://avatars.discourse-cdn.com/v4/letter/c/8dc957/32.png) [@CONYNTRA\_SA](https://community.make.com/u/CONYNTRA_SA)\ **Post date:** [August 1, 2024, 11:54pm UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050/3 "2024-08-01T23:54:03Z")
Yeah I’ve seen the Bulk Update Cells module, but somehow it was not as effective as doing an API Call. So, would you know how I can structure that array out of a number and the array [“”]? ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 2, 2024, 12:27am UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050/4 "2024-08-02T00:27:21Z")
Welcome to the Make community! In that case, this is possible with a minimum of two modules: ![Screenshot_2024-08-02_080821](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/e/deb08f777c3ff92d476c190cd87f9f59f3c65fac.png) ### Output ![Screenshot_2024-08-02_080809](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/f/5/f5b0a565cb5e4bc61f190135f5a0b0a2eafb11fc.png) Hope this helps! Let me know if there are any further questions or issues. You can also join us in the Make Fans Discord server to chat with other makers. Due to the evolving needs of this community, the Discord invite link can be found elsewhere on this forum. You can either search for it or message me to request an invite. ---
**Author:** ![CONYNTRA\_SA](https://avatars.discourse-cdn.com/v4/letter/c/8dc957/32.png) [@CONYNTRA\_SA](https://community.make.com/u/CONYNTRA_SA)\ **Post date:** [August 2, 2024, 1:03am UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050/5 "2024-08-02T01:03:48Z")
Perfect SamLiew, Thank you for your help! ---
**Author:** ![samliew](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/samliew/32/13327_2.png) [@samliew](https://community.make.com/u/samliew)\ **Post date:** [August 2, 2024, 1:08am UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050/6 "2024-08-02T01:08:35Z")
No problem, glad I could help! 1. If anyone has a new question in the future, please **start a new thread**. This makes it easier for others with the same problem to search for the answers to specific questions, and you are more likely to receive help since newer questions are monitored closely. 2. The [Make Community guidelines](https://community.make.com/t/make-community-the-ultimate-topic/11682) encourages users to try to **mark helpful replies as solutions** to help keep the Community organized. This marks the topic as solved, so that: - others can _save time_ when catching up with the latest activity here, and - allows others to _quickly jump to the solution_ if they come across the same problem To do this, simply **click the checkbox** at the bottom of the post that answers your question: ![Screenshot_2023-10-04_161049](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/5/d/5d9b26fbef0fd7385a34084f61cd5b9165786f42.png) 3. Don’t forget to like and **bookmark** this topic so you can get back to it easily in future! Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too — ### Getting Started - [Help Centre](https://www.make.com/en/help) | [Tutorials](https://www.make.com/en/help/tutorials.html) – all you need to know about Make - [Make Academy](https://academy.make.com) – learn Make and get certified ### Help Centre Basics - [Mapping](https://www.make.com/en/help/mapping/mapping) – What is mapping? What can I map? - [Mapping with arrays](https://www.make.com/en/help/mapping/mapping-arrays) – How to map items in an array - [Aggregate an array for mapping complex fields](https://www.make.com/en/help/tools/flow-control#customizing-the-output) - [Tokens for `parseDate`](https://www.make.com/en/help/functions/tokens-for-date-time-parsing) | [Tokens for `formatDate`](https://www.make.com/en/help/functions/tokens-for-date-time-formatting) - [HTTP modules](https://www.make.com/en/help/tools/http) – Make a request, Get (download) a file - [Webhooks](https://www.make.com/en/help/tools/webhooks) – Error Handling, Responding to webhooks ### Articles & Videos - [Router Magic Formula](https://www.youtube.com/watch?v=4Q-5BsCtJu4) - YouTube - [Error Handlers in Make](https://www.youtube.com/playlist?list=PLRE9E-rAD8U10mx2TRs54Nq1XJDdK9Kx4) - YouTube playlist - [Getting started with OpenAI](https://community.make.com/t/getting-started-with-openai-gpt-3-and-make/7796) - How to setup and use OpenAI (ChatGPT) in Make - [How to use Regex in Make](https://community.make.com/t/how-to-use-regex-in-make/202) - How to use pattern matching to extract the text you want ### Partner & Custom Apps - [Make Partner Training Portal](https://partnertraining.make.com) - [Custom Apps / App Builder](https://docs.integromat.com/apps) Hope this helps! ---
**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\ **Post date:** [August 16, 2024, 1:19am UTC](https://community.make.com/t/how-to-create-a-custom-array-of-an-item-repeated-n-times/49050/7 "2024-08-16T01:19:04Z")
This topic was automatically closed because it's resolved or inactive. Please, start a new topic.