Sort no one can figure out

[bander143]

1) There is a spreadsheet with columns A-S (A-I is one group of info and J-S is second)
2) A-I has 1254 lines
3) J-S has 14,889 lines
4) Column I and J have numbers 4-6 digits. All the I numbers are contained in the J numbers but there is no consecutive order of numbers and many numbers skipped.
5) Need all the numbers in J to line up with the numbers in I (I are the main numbers concerned about sort order)
6) All columns J-S must stay together after sorting and of course A-I which should be natural.

All the excess numbers can be expunged after. A solution would be greatly appreciated!

[teylyn]

This is a duplicate post. You have asked the same question here, and have received a suggestion. Respond to that.

Thread closed.