# Glide Google Sheet : one row to multiple rows **URL:** \ **Category:** Ask for Help\ **Created:** [August 25, 2022, 4:14pm UTC](https://community.glideapps.com/t/glide-google-sheet-one-row-to-multiple-rows/47743 "2022-08-25T16:14:10Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Thel93210](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thel93210/32/21926_2.png) [@Thel93210](https://community.glideapps.com/u/Thel93210)\ **Post date:** [August 25, 2022, 4:14pm UTC](https://community.glideapps.com/t/glide-google-sheet-one-row-to-multiple-rows/47743/1 "2022-08-25T16:14:10Z")
Bonjour à tous, I have a game ( tab 1), in this game I have couple of people(tab 2) who can be interrested in. I made a lookup column to find their phone number ( they are comma separated but in the same cell joine list column) I would like to create in tab 3 (google sheet) a row per personne who match with the game to send a message per personne I tried with glide X zapier X google sheet but it made just one row with all the phone num in one cell while i wanted A row per phone number. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/3/a3eac0e0a793b3da73f33f4a71854e0e82e067be.png) Do you know how to transforme “one cell with X data” to “a row per data”? Par avance merci ! ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [August 25, 2022, 7:00pm UTC](https://community.glideapps.com/t/glide-google-sheet-one-row-to-multiple-rows/47743/2 "2022-08-25T19:00:45Z")
here you go: ![Screen Shot 2022-08-25 at 2.59.52 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/0/f06d0523825222718535db56bb5b8884ec844d46.png) `=TRANSPOSE(split(A1,","))` ---
**Author:** ![Thel93210](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thel93210/32/21926_2.png) [@Thel93210](https://community.glideapps.com/u/Thel93210)\ **Post date:** [August 25, 2022, 9:28pm UTC](https://community.glideapps.com/t/glide-google-sheet-one-row-to-multiple-rows/47743/3 "2022-08-25T21:28:36Z")
> [@Uzo](#): > > =TRANSPOSE(split(A1,“,”)) Thanks a lot ! In my case I dont know if it will be ok . As it’s a multiple user app, it will have more than 1 row called (each row have 1 cell with X items) As you can seeI have a REF issue. “Mistake The result has not been expanded, so as not to overwrite the data of C251.” ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/8/882e44af9fa41884f7bf996e498eb8b06e0e96b9.png) To tell you everthing my app will help people to find player When they click on the button " ask the coach to find player" ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/b/fbebdd4a60805d07ce5d9cf497b5bcc6c1ebf29a.jpeg) It will add a row on my google sheet with the phone number of the people who match with the current game. Then, I send sms to them throught a small app for free, ([https://www.youtube.com/watch?v=PReU4ITp37I](https://www.youtube.com/watch?v=PReU4ITp37I)) 1 row = 1 recipient This little app allow me to send bulk sms but not automatically ( I’m sure there is a way to call the function when a new row is added) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [August 25, 2022, 11:04pm UTC](https://community.glideapps.com/t/glide-google-sheet-one-row-to-multiple-rows/47743/4 "2022-08-25T23:04:07Z")
you need to install the trigger onChange, and run the function… ---
**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:** [August 26, 2022, 12:29am UTC](https://community.glideapps.com/t/glide-google-sheet-one-row-to-multiple-rows/47743/5 "2022-08-26T00:29:16Z")
Many people use Make instead of Zapier, and I think you can set up Make to iterate through a comma delimited list or an array. I haven’t done it myself, but a few other people have. Or, you could create a google script that will read each row in your table and write a new row in a different table for each separate number in each row. ---
**Author:** ![Thel93210](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thel93210/32/21926_2.png) [@Thel93210](https://community.glideapps.com/u/Thel93210)\ **Post date:** [August 26, 2022, 5:04am UTC](https://community.glideapps.com/t/glide-google-sheet-one-row-to-multiple-rows/47743/6 "2022-08-26T05:04:05Z")
Thank you @Jeff_Hager, I will try it with Make and let you know if it works!