# Duplicate a column with ALL related rows into a separate Glide Data Table **URL:** \ **Category:** Ask for Help\ **Created:** [November 12, 2025, 2:06am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319 "2025-11-12T02:06:48Z")\ **Posts on this page:** 13\ **Page:** 1
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [November 12, 2025, 2:06am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/1 "2025-11-12T02:06:48Z")
Apologies if this is a Data Table for Dummies 101 question but I am struggling to identify a simple way to replicate/copy a column with 7 x rows in one glide data table, into a second separate glide table ? The individual columns with the 7 x rows of data are sitting within a Glide Data Table. I need to use an IF-THEN-ELSE column function in order to create an ‘alert” based on the 7 rows of data falling within a specific range. I created a new glide data table to handle the ‘alert’ function as my initial table is already massive and with the intent of keeping things cleaner and easily identifiable from a backend perspective. Unfortunately I have not been able to identify a way to simply copy or recreate 1 column with 7 x rows of data from one glide data table into another glide data table…. please what am I missing here ? ---
**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:** [November 12, 2025, 2:11am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/2 "2025-11-12T02:11:39Z")
You need to create an if-then-else column in the second table, or some other type of column? If it’s a computed column, then it will need direct (or indirect) access to the same columns that are referenced in the original table. If it’s a non-computed column, then simply create it and copy/paste the 7 rows of data. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [November 12, 2025, 2:22am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/3 "2025-11-12T02:22:35Z")
Hi Darren, I am aiming to copy/mirror the data in the Column with its 7 x rows in order to use the data in an if-then-else function. The data in the original column across 7 rows is populated via an api call (refreshed every 12 hours). I wanted to have the if-then-else function in a separate dtat table as the oringinal table is already pushing past 150 columns… ---
**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:** [November 12, 2025, 2:26am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/4 "2025-11-12T02:26:06Z")
So it’s just a Text type column? Is the data the same in every row, or different? Either way, use a Single Value column. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [November 12, 2025, 2:29am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/5 "2025-11-12T02:29:41Z")
Sorry, I must be missing something here. The data is different in each row of the column. If I use a Single Value wouldn’t it just provide the first value (row 1) when I need all 7 rows of data in the column ---
**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:** [November 12, 2025, 2:32am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/6 "2025-11-12T02:32:01Z")
That’s why I asked the question. Now I have enough information, I can provide a precise answer 🙂 - In your second table, add a column to number your rows, beginning at zero - Then add a Single Value column that targets the column in the first table, and select `N` from start, where `N` is your row number. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [November 12, 2025, 2:46am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/7 "2025-11-12T02:46:28Z")
Hmmm, apologies once again if this is a really basic concept that I am struggling to grasp. First Table: ![Screenshot 2025-11-12 at 1.39.37 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/2/127c0e3663738aeae0f3fa8e4f316e6b99c1ed80.png) In my 2nd data table I have created: ![Screenshot 2025-11-12 at 1.37.23 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/0/206102ec813b53aa05b1e5a30c71a76ae55522f0.png) The lookup in the second table is pointing to the column from the original table with the 7 x sets of data . I am looking for a way to copy all 7 rows of data from the first table column into the 2nd table column with all 7 rows replicated. \*When the data changes in the first column (across all 7 rows) based on api refresh, I need those changes to be replicated in the new column in the new table in order to trigger an alert when specific sets of data across a given day occur ---
**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:** [November 12, 2025, 2:59am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/8 "2025-11-12T02:59:54Z")
Show me how your Single Value column is configured. It looks wrong. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [November 12, 2025, 3:04am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/9 "2025-11-12T03:04:58Z")
![Screenshot 2025-11-12 at 2.04.03 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/4/2471cbe8ed9b18000613bd348f03588bf2d0c763.png) From = column in original table How do you set the Get: to be multiple rows ? ---
**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:** [November 12, 2025, 3:07am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/10 "2025-11-12T03:07:25Z")
The Row part is wrong. You should reference the row ID column there instead of hard coding as 0. ---
**Author:** ![Holy-Mackerel](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/holy-mackerel/32/85204_2.png) [@Holy-Mackerel](https://community.glideapps.com/u/Holy-Mackerel)\ **Post date:** [November 12, 2025, 3:28am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/11 "2025-11-12T03:28:27Z")
These are the available selections (from the current/2nd table): ![Screenshot 2025-11-12 at 2.24.44 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/b/abcf2564d1236aecad2b6eaf0d95c471184f28e2.png) ---
**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:** [November 12, 2025, 3:42am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/12 "2025-11-12T03:42:37Z")
Yes, select Row ID. By the way, that should be a number column, not a text column. ---
**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:** [November 12, 2025, 5:40am UTC](https://community.glideapps.com/t/duplicate-a-column-with-all-related-rows-into-a-separate-glide-data-table/85319/13 "2025-11-12T05:40:20Z")
How did you go - did you get it working?