# \[Solved\]Copy data from one column to other column **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [June 10, 2023, 6:31am UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718 "2023-06-10T06:31:58Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\ **Post date:** [June 10, 2023, 6:31am UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/1 "2023-06-10T06:31:58Z")
I want to know if the following is possible in thunkable x I have treid app scripts, but it does niot work. In my google sheet I have a Formula that adds data to column “I” so how can I just copy the value from “I” to “J” so “J” will just be normal data with no formula in it. ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [June 10, 2023, 6:35am UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/2 "2023-06-10T06:35:09Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/0/f045fabf5f4a05280825b5258827149bfe3ccf4d.png) ---
**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\ **Post date:** [June 10, 2023, 6:39am UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/3 "2023-06-10T06:39:14Z")
Thank you, will try that, and let you know if it did work for me. ---
**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\ **Post date:** [June 10, 2023, 10:28am UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/4 "2023-06-10T10:28:26Z")
I did try, but do not work, i did to use it in diffrent places, but still not copy it to column ![Screenshot_62](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/8/889c60f67700f50ab34de0b4a8cc9022c27306c2.png) ![Screenshot_61](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/e/9e36abe382d68201381c61af8ad5b5769bd5ec55.png) ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [June 10, 2023, 3:05pm UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/5 "2023-06-10T15:05:37Z")
The update value block needs to go inside the create row block’s “do” section so that it happens _after_ the row is created. ---
**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\ **Post date:** [June 10, 2023, 4:55pm UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/6 "2023-06-10T16:55:44Z")
I did add it in the [do] ![Screenshot_63](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/e/ae96c8bd35a62ac3baec54e214d5ce43d82c72ac.png) part of create row, but still not working ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [June 10, 2023, 5:01pm UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/7 "2023-06-10T17:01:25Z")
But you’re using 1 as the row id. When the row is created, unless the spreadsheet is empty, you won’t want to use row #1. Replace the 1 with the “number of rows in data source” block. ---
**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\ **Post date:** [June 10, 2023, 5:10pm UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/8 "2023-06-10T17:10:11Z")
Sorry I do not understand you, if I add a new row, must I use that row’s number, if so must I then every time change the row number for next one. 😳 ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [June 10, 2023, 7:24pm UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/9 "2023-06-10T19:24:17Z")
No. You just use the “Number of rows” block in the Data Sources drawer. That block will always return a number representing the number of rows in the data source. ![09FC370D-4464-49B5-965D-A467C9616470](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/5/b5788ad98a8b769da7a61df1bfa17a6e8cb037fa.png) You can find out more in the Data Sources section of the Thunkable documentation. ---
**Author:** ![hendrikbez](https://avatars.discourse-cdn.com/v4/letter/h/f1d935/32.png) [@hendrikbez](https://community.thunkable.com/u/hendrikbez)\ **Post date:** [June 12, 2023, 5:31am UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/10 "2023-06-12T05:31:44Z")
Thank you ---
**Author:** ![matt\_conroy](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/matt_conroy/32/150843_2.png) [@matt\_conroy](https://community.thunkable.com/u/matt_conroy)\ **Post date:** [June 12, 2023, 4:07pm UTC](https://community.thunkable.com/t/solved-copy-data-from-one-column-to-other-column/2459718/11 "2023-06-12T16:07:24Z")