I have looked at your sheet again and understand what you mean about A and J. Copy entire column of data in A and paste into new sheet. From the data tab, remove duplicates. Paste this into J. Fill the formulas I have provided down.
Hope this helps.