@smithcreed you might have a look at this approach. Combining One to Many and Math Formula over multiple Rows to transform the original data into columns for each 500xy ID and assign the value from the one column.
2 Likes