https://community.esri.com/t5/arcgis-analyse-questions/formatting-vehicle-tracking-csv-time-path-amp/m-p/1265851#M143 <P>Hello and thanks for any advice in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>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.&nbsp;</P><P>I need to separate each data point (time, path, speed) into its own row with associated ID.</P><P>Does anyone have any idea on how to do this?</P><P>I have attached some sample data.</P><P>&nbsp;</P><P>Cheers</P><P>Dan</P> Thu, 09 Mar 2023 01:17:17 GMT DanH7 2023-03-09T01:17:17Z https://community.esri.com/t5/arcgis-analyse-questions/formatting-vehicle-tracking-csv-time-path-amp/m-p/1265851#M143 <P>Hello and thanks for any advice in advance <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P><P>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.&nbsp;</P><P>I need to separate each data point (time, path, speed) into its own row with associated ID.</P><P>Does anyone have any idea on how to do this?</P><P>I have attached some sample data.</P><P>&nbsp;</P><P>Cheers</P><P>Dan</P> Thu, 09 Mar 2023 01:17:17 GMT https://community.esri.com/t5/arcgis-analyse-questions/formatting-vehicle-tracking-csv-time-path-amp/m-p/1265851#M143 DanH7 2023-03-09T01:17:17Z