Align Rows based on Matching Values in 2 Columns

I am working on a project that requires me to match up rows based on matching values in 2 columns. In the attached file, Columns A and L have record numbers and all of those in L show up in A but not all in A show up in L. The data is arranged so columns A through K need to stay together and L through X need to stay together.


The Problem:

I need to align columns A through K and L through X by row based on matching values in column A and L. I don't have to keep the data in this format so long as rows with the same number in A and L line up.

Maybe there is another thread on this but I have searched everywhere over a couple days now and havent found a thing.

Thanks in advance