Adding extra columns + append numerical values

I have riding GPS data that I’m trying to manipulate, process and append at the end of an xls file (master data used for a map)

Original: data that comes in

Formatted: the way I want the data to look

  • add 3 new columns: Ride, Day, Location

  • Location comes from the column k in original file

  • ride and Day I want to start at a specific number ie 285 ride, 288 day and so on

(285 because the master has 284 rides and 287 days)

So…for each new rides + 1 ride and + 1 day

formatted.csv

original.csv