# Extract Column of data from Sheets and insert them as a row of data accross columns in another sheet
**URL:** https://community.make.com/t/extract-column-of-data-from-sheets-and-insert-them-as-a-row-of-data-accross-columns-in-another-sheet/70876
**Category:** Questions
**Tags:** arrays, google-sheets
**Created:** [February 21, 2025, 7:46pm UTC](https://community.make.com/t/extract-column-of-data-from-sheets-and-insert-them-as-a-row-of-data-accross-columns-in-another-sheet/70876 "2025-02-21T19:46:02Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@willmake](https://community.make.com/u/willmake)
#### Post date: [February 21, 2025, 7:46pm UTC](https://community.make.com/t/extract-column-of-data-from-sheets-and-insert-them-as-a-row-of-data-accross-columns-in-another-sheet/70876/1 "2025-02-21T19:46:02Z")
Thank you to those that help me - I am new to make and I have taken the first 3 classes in the academy. I have 20+ years of experience with PHP, but I have only minimal exposure to JavaScript so I need some help 🙂
I am attempting to extract a column of 10 rows of data from a G Sheet, then take that data and insert in to a new row across 10 columns in a different G sheet.
It is important to know that the the columns in the data source will never change.
I have used an Array Aggregator to turn the data into an array, then my gut was to use tools to get multiple values and map all 10 element positions of the array into variables.
Then use a Google Sheets module to add a row and place the variable names into each column.
The issue is that I do not know the syntax to in order to retrieve each value from each position in the get values module.
Thank you for your help!
---
### Author:  [@samliew](https://community.make.com/u/samliew)
#### Post date: [February 22, 2025, 7:24am UTC](https://community.make.com/t/extract-column-of-data-from-sheets-and-insert-them-as-a-row-of-data-accross-columns-in-another-sheet/70876/2 "2025-02-22T07:24:17Z")
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:
```plaintext
{{ 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](https://www.make.com/en/help), and complete the [Make Academy](https://academy.make.com) 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](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
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:  [@willmake](https://community.make.com/u/willmake)
#### Post date: [February 22, 2025, 8:50am UTC](https://community.make.com/t/extract-column-of-data-from-sheets-and-insert-them-as-a-row-of-data-accross-columns-in-another-sheet/70876/3 "2025-02-22T08:50:22Z")
thank you Samliew - that worked perfectly ! you are awesome!
---
### Author:  [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [March 10, 2025, 9:01am UTC](https://community.make.com/t/extract-column-of-data-from-sheets-and-insert-them-as-a-row-of-data-accross-columns-in-another-sheet/70876/4 "2025-03-10T09:01:42Z")