I have a dataset like this

Id,x,y,grid

1,2,3,a

2,5,7,b

And would like to transform the xy from grid b to grid a, like this:

Id,x,y,grid,xa,ya

1,2,3,a,2,3

2,5,7,b,17,21

Any suggestions? Many thanks,Jakob


	[[alternative HTML version deleted]]

