Extract Column of data from Sheets and insert them as a row of data accross columns in another sheet

Welcome to the Make community!

You can delete your get multiple variables module.

Simply use the built-in map-get functions to access variables from your aggregator’s array, directly in the Google Sheets module:

{{ get(map(8.array; "0"); 1) }}
{{ get(map(8.array; "0"); 2) }}
{{ get(map(8.array; "0"); 3) }}
{{ get(map(8.array; "0"); 4) }}
{{ get(map(8.array; "0"); 5) }}
{{ get(map(8.array; "0"); 6) }}
etc.

For more information, see the function documentation in the Help Center, and complete the Make Academy as it is explained in further detail there.

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 Basics

Articles & Videos

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

2 Likes