# How to push user-data from different columns into rows?

**URL:** <https://community.glideapps.com/t/how-to-push-user-data-from-different-columns-into-rows/30983>\
**Category:** Ask for Help\
**Created:** [August 26, 2021, 3:45pm UTC](https://community.glideapps.com/t/how-to-push-user-data-from-different-columns-into-rows/30983 "2021-08-26T15:45:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Martina\_G](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martina_g/32/22597_2.png) [@Martina\_G](https://community.glideapps.com/u/Martina_G)\
**Post date:** [August 26, 2021, 3:45pm UTC](https://community.glideapps.com/t/how-to-push-user-data-from-different-columns-into-rows/30983/1 "2021-08-26T15:45:56Z")

</div>

Hey guys,

how to implement this UX with the data structure?

- User can choose from different goals (1-N) and define each goal with personal date and amount. These data is stored in table `user`.
- App dashboard will display a list with the defined goal

Question:  
How to push these data from `user`, spread over separate columns, to `goals` into rows in order to structure it for the dashboard list?

 ![scrnli_26-8-2021_17-34-11](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/5/a57aa670732ebc834d80d7cd005409f544f886b1.png)  
 ![scrnli_26-8-2021_17-46-36](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/1/a1d0378f6140e34a6eba8a043ccaaf80dd45a5e3.png)

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [August 26, 2021, 3:48pm UTC](https://community.glideapps.com/t/how-to-push-user-data-from-different-columns-into-rows/30983/2 "2021-08-26T15:48:28Z")

</div>

If it were me, I would create a form that sends the submissions to a separate responses table. Next, I would create a relation from User table to the Responses table to get a list of each user’s responses. I’d then use that relation to display an inline list of the user’s responses, as needed.

---

<div class="post-metadata">

**Author:** ![Martina\_G](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/martina_g/32/22597_2.png) [@Martina\_G](https://community.glideapps.com/u/Martina_G)\
**Post date:** [September 1, 2021, 11:22am UTC](https://community.glideapps.com/t/how-to-push-user-data-from-different-columns-into-rows/30983/3 "2021-09-01T11:22:19Z")

</div>

Thanks @kyleheney! This implementation works very well.

Additional note: For collecting the submissions, I chose the “add a row” action - this stores each goal per user separately.