# Transpose data from a column in one table to another table in a row **URL:** \ **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:** 4\ **Page:** 1
**Author:** ![Hossam\_Taher](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hossam_taher/32/73039_2.png) [@Hossam\_Taher](https://community.glideapps.com/u/Hossam_Taher)\ **Post date:** [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/1 "2024-04-01T00:27:04Z")
I want to automatically copy numeric values from a column in GlideApp-Table 1 to a row in GlideApp-Table 2. I will do this with multiple columns in table 1 to pair them with their rows in table 2 that have the same name. Context: - In Table 1, the column name is Savings and each row in this column represents the numeric value in a given month - In Table 2 the row represents Savings and each column will represent the months I am basically transposing data cross different tables from a single column to multiple columns in a row. Questions: 1. Can I transpose data from a column in table 1 to a row in table 2? 2. Can I do that automatically by matching the column name in table 1(First row) with the row name (first column value) in table 2? ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 1, 2024, 12:33am UTC](https://community.glideapps.com/t/transpose-data-from-a-column-in-one-table-to-another-table-in-a-row/72201/2 "2024-04-01T00:33:15Z")
You could create a Single Value column for each month in table 2 and have each one retrieve a value from a different row in table one. ---
**Author:** ![Hossam\_Taher](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/hossam_taher/32/73039_2.png) [@Hossam\_Taher](https://community.glideapps.com/u/Hossam_Taher)\ **Post date:** [April 1, 2024, 2:25pm UTC](https://community.glideapps.com/t/transpose-data-from-a-column-in-one-table-to-another-table-in-a-row/72201/3 "2024-04-01T14:25:08Z")
Thanks Jeff for the quick response. I don’t think this solves my problem because in Table 1 I have multiple columns like Savings, Income, Expenses, Net Income etc. and I want to transpose all of them to Table 2 where each row represents one of those categories with their monthly data spread over in each row. My goal here is to use the Table 2 as the data for a list on the home page where each item in the list is a category and when I open it I can view the monthly performance. Do you have a solution for that or do I have to rely on google sheets and rebuild this module? ---
**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")
- 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.