Hi all,
I have exported activity data from a sports device to CSV and opened it with LO Calc. Lines correspond to timestamps, uneven columns contain an identifier (string) whereas even columns contain the corresponding value. However, during recording additional cells have been inserted, hence if I’m looking for the identifier “cadence” it may be in column C most time (with D containing the recorded cadence value), but occasionally in other columns, with the corresponding value always being in the cell immediately to the right of it.
I’m now looking for a way to extract all cadence values, no matter in which column the identifier “cadence” is located.
Any suggestions how to solve this would be much appreciated!
Best,
r.