Forum Discussion
How can I transform my data in to daily data instead of a date range?
Each row of my data signifies the time a job entered a certain status until it left that status. It is tracked by start date & time to end date and time. I need to make this data daily data.
Ie:
| status | start date | start time | stop date | stop time |
| test | 1/1/22 | 0800 | 1/4/22 | 1500 |
I need to transform the data from ^^ to vv
| status | start date | start time | stop date | stop time |
| test | 1/1/22 | 0800 | 1/1/22 | 2400 |
| test | 1/2/22 | 0 | 1/2/22 | 2400 |
| test | 1/3/22 | 0 | 1/3/22 | 2400 |
| test | 1/4/22 | 0 | 1/4/22 | 1500 |
Please let me know if you can help! I would be forever grateful!
- Mary
