I had a similar issue before, but I cannot figure out how to accomplish this new issue. I have two data sets in one worksheet. The first data set (left side) has about 4000 records and the second data set (right side) has about 1000 records.
Each data set has its own 'key' column. The keys on the right side do match a key on the left side. If I just reorder the data sets from highest to lowest, I will still have to physically move the data on the right side down until it matches the key on the left side because there are 3000 less records in no particular order. Is there a way to have the data set from the left match the keys and place the corresponding data next to the left side data set?