# Array Format
**URL:** https://community.make.com/t/array-format/57976
**Category:** Questions
**Tags:** arrays
**Created:** [October 16, 2024, 12:24am UTC](https://community.make.com/t/array-format/57976 "2024-10-16T00:24:52Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@Maico\_D\_Arbel](https://community.make.com/u/Maico_D_Arbel)
#### Post date: [October 16, 2024, 12:24am UTC](https://community.make.com/t/array-format/57976/1 "2024-10-16T00:24:52Z")
Hi there, I have a google sheets table “Date, Description, Amount” there are several and dinamically filled rows.
I can put them into an array (image attached)
What I need is to format and store all data in one single variable in the following format:
Date1 - Description1 - Amount1 | Date2 - Description2 - Amount2 | Date3 …n
Where the numer is the collection number, more specifically taking the data from the image will be something like this :
2024 - Table - 496 | 2024-10-27 - Chair - 67 | and so on…
Is this possible?
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [October 16, 2024, 1:22am UTC](https://community.make.com/t/array-format/57976/2 "2024-10-16T01:22:13Z")
Delete the Array Aggregator and use a Text Aggregator.
### Aggregators
Every result (item/record) from iterator/list/search/match modules will output a bundle. This can result in multiple bundles, which then trigger multiple operations in future modules (one operation per bundle). To “combine” multiple bundles into a single variable, you’ll need to use an aggregator of some sort.
[Aggregators](https://www.make.com/en/help/modules/aggregator.html) are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator) module. The next popular aggregator is the [Text Aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator) which is very flexible and can apply to many use-cases like building of JSON, CSV, HTML.
There are other types of aggregator modules, click the below links to find out more:
- [Array aggregator](https://www.make.com/en/help/tools/flow-control.html#array-aggregator)
- [Text aggregator](https://www.make.com/en/help/tools/tools.html#text-aggregator)
- [Numeric aggregator](https://www.make.com/en/help/tools/tools.html#numeric-aggregator)
- [Table aggregator](https://www.make.com/en/help/tools/tools.html#table-aggregator)
- [JSON aggregator](https://www.make.com/en/help/tools/json.html#aggregate-to-json)
- [CSV aggregator](https://www.make.com/en/help/apps/file-and-document-management/csv.html#create-csv)
- [Archive (ZIP) aggregator](https://www.make.com/en/help/apps/built-in-apps/archive.html#create-an-archive-973677)
- _other app-specific aggregators_
Hope this helps! Let me know if there are any further questions or issues.
— @samliew
P.S.: Investing some effort into the [Make Academy](https://academy.make.com) will save you lots of time and frustration using Make.
---
### Author:  [@Shornalatha](https://community.make.com/u/Shornalatha)
#### Post date: [October 16, 2024, 1:31am UTC](https://community.make.com/t/array-format/57976/3 "2024-10-16T01:31:14Z")
You can use a Text Aggregator like this:
The output should present like how you want.
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [October 16, 2024, 1:39am UTC](https://community.make.com/t/array-format/57976/4 "2024-10-16T01:39:17Z")
Welcome to the Make community!
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) – Make “Manual”
- [Make Academy](https://academy.make.com) – Basics 101: 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)
- **Date Format** : [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
- [Webhooks – Make Academy](https://academy.make.com/courses/IntermediateC04) – tutorial on how to use Webhooks
---
### Author:  [@Maico\_D\_Arbel](https://community.make.com/u/Maico_D_Arbel)
#### Post date: [October 16, 2024, 5:45pm UTC](https://community.make.com/t/array-format/57976/5 "2024-10-16T17:45:38Z")
Thank you very much! That was exactly what I was looking for!
Also thanks for the links, definetly will check them out.
Cheers.
---
### Author:  [@Maico\_D\_Arbel](https://community.make.com/u/Maico_D_Arbel)
#### Post date: [October 16, 2024, 5:48pm UTC](https://community.make.com/t/array-format/57976/6 "2024-10-16T17:48:30Z")
Thank you very much! Exactly what I need!!
Cheers
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [October 30, 2024, 6:57pm UTC](https://community.make.com/t/array-format/57976/7 "2024-10-30T18:57:08Z")