Hello, I have data in multiple tables in smartsheet, I want to pull a few columns from each table together (these contain email addresses) and combine them.
for example
Sheet 1 has 2 columns (one of these columns has multiple email addresses in it separated by 
Sheet 2 has one column
I need to collate all these into either one column on an excel sheet, or straight into microsoft outlook
Welcome to the Make community!
You can either use a Text Aggregator, or the built-in function join depending on your output bundle.
Every result (item/record) from a search/match module will output a bundle. To “combine” them into a single structure, you’ll need to use an aggregator of some sort.
Aggregators are modules that accumulate multiple bundles into one single bundle. An example of a commonly-used aggregator module is the Array aggregator module. The next popular aggregator is the Text Aggregator which is very flexible and has applies to many use-cases.
There are other types of aggregator modules, click the below links to find out more:
The Array Aggregator module allows you to build a complex array of collections for a later module’s field to map multiple items (collections) to it.
Here is an example of using the “Target structure type” of an Array Aggregator module:
As you can see, the “Map” toggle on fields are used when you have an array. You can easily build an array variable to map to a field, by using an Array Aggregator module and select the “Target Structure Type” as the future field you want to map the array into.
