# Pivoting multiple date columns into one
**URL:** https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963
**Category:** Ask for Help
**Created:** [November 17, 2024, 6:23am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963 "2024-11-17T06:23:57Z")
**Posts on this page:** 8
**Page:** 2
### Author:  [@Lachlan](https://community.glideapps.com/u/Lachlan)
#### Post date: [November 18, 2024, 12:36am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/21 "2024-11-18T00:36:37Z")
Makes sense. Initially was trying to avoid this thinking there was less ‘computed column gymnastics’ required. Will take a few steps back to go forward with a simpler solve
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 18, 2024, 12:39am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/22 "2024-11-18T00:39:15Z")
My solution is only if you don’t want to touch your initial table
---
### Author:  [@Lachlan](https://community.glideapps.com/u/Lachlan)
#### Post date: [November 18, 2024, 4:52am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/23 "2024-11-18T04:52:44Z")
having a play with this and getting stuck…i have a form that the user inputs other project details into. Can they input this info in ‘Projects’ table and then the dates into ‘Project Milestones’ table all from the same form?
If this requires a 2nd form then i may need to limber up and try some gymnastics
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [November 18, 2024, 5:03am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/24 "2024-11-18T05:03:50Z")
To keep things clean, I would probably do it separately.
On the Project details screen, have something like an “Add Milestones” button. This would open a separate form that targets the Project Milestones table and prompts for Milestone name, Start Date and End date. Then pass the ProjectID as a column value with the form.
---
### Author:  [@Lachlan](https://community.glideapps.com/u/Lachlan)
#### Post date: [November 18, 2024, 5:29am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/25 "2024-11-18T05:29:56Z")
Thanks. I prefer the look of not having another button to add these dates but i think i can use this idea for some other additions like adding project tasks and expenses.
Thankyou very much for the feedback and guidance. I feel like a genius when i can make this stuff come together!
---
### Author:  [@Lachlan](https://community.glideapps.com/u/Lachlan)
#### Post date: [November 18, 2024, 5:31am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/26 "2024-11-18T05:31:32Z")
This looks to be working fantastically. Thankyou so much for your help
---
### Author:  [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)
#### Post date: [November 18, 2024, 10:54am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/27 "2024-11-18T10:54:47Z")
My pleasure!
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [November 25, 2024, 10:54am UTC](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963/28 "2024-11-25T10:54:53Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.
[Previous page](https://community.glideapps.com/t/pivoting-multiple-date-columns-into-one/77963.md?page=1)