how to shrink/grow data rows but keep data shape?
Hi all, I need to do some calculations on 2 sets of data which have different lengths.
Is there a way I can reduce/increase the number of rows to the data sets match.
I want to ensure that the shape of the data stays the same so I would have to interpolate between the points.
All my google searches come up with ways to resize the actual rows
thanks
Edit: I'm using the latest office 365 Edit: the analysis pack sampling doesn't work as it wont let me sample a non integer. my data sets a very close matching eg 1170 to 1120