Hi,
I have a table with different scan results.
I have 180 scans with 1000 results per scan.
results are at the Z column.
I want to create a new column with relative scan results, meaning the results of scan 2 - the results of scan 1, results of scan 3 - the results of scan 2, and so on.
subtraction of results must be by Location number, 1-1, 2-2, 3-3, and so on.
I've tried to transpose the data but got lost in the way.
I would appreciate any help.
![Ohad_s_0-1717917179624.png Ohad_s_0-1717917179624.png](https://community.jmp.com/t5/image/serverpage/image-id/65024iC75CC81A6B87C591/image-size/medium?v=v2&px=400)