Hello and thanks for any advice in advance 🙂
I have several thousand vehicle trips to visualise temporally and am having trouble formatting the data. Each row is a vehicle trip with data being logged at minute intervals for time, path and speed and recorded as comma separated values. Each trip has a unique ID.
I need to separate each data point (time, path, speed) into its own row with associated ID.
Does anyone have any idea on how to do this?
I have attached some sample data.
Cheers
Dan