# Transpose data from a column in one table to another table in a row

**URL:** <https://community.glideapps.com/t/transpose-data-from-a-column-in-one-table-to-another-table-in-a-row/72201>\
**Category:** Ask for Help\
**Created:** [April 1, 2024, 12:27am UTC](https://community.glideapps.com/t/transpose-data-from-a-column-in-one-table-to-another-table-in-a-row/72201 "2024-04-01T00:27:04Z")\
**Posts on this page:** 1\
**Showing post:** 4

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 1, 2024, 2:36pm UTC](https://community.glideapps.com/t/transpose-data-from-a-column-in-one-table-to-another-table-in-a-row/72201/4 "2024-04-01T14:36:01Z")

</div>

- Use a Make Array column to create an array from the columns in Table 1 that you’re interested in.
- Pull that column into Table 2 (there are several ways to do this, which is best depends on exact use case)
- Add enough rows to Table 2 to cover the total number of items in the array
- Add a RowIndex to Table 2 (see [here](https://community.glideapps.com/t/how-do-i-create-an-auto-incrementing-row-number-with-glide-tables/39572))
- Add a Single Value column. Target the Array column, and select N from Start, where N is the RowIndex.

---

_[View the full topic](https://community.glideapps.com/t/transpose-data-from-a-column-in-one-table-to-another-table-in-a-row/72201)._