I am making a graph that has to show the displacement for 44 monitoring probes. the probes slightly move every hour and is recorded at the hour. I have over 45K data points and more coming in daily, thus i made a pivot table. my basic table looks good. BUT i need to be able to take the displacement of each point. the problem is each monitoring probe starts at a different location. the data isn't sorted by probe so i cant just make 44 different excels. Any ideas how to do this?
to simplify, overall equation i need is just Xo-Xf, but Xo is dependent on the probe.
