Matching and Sorting with Two Columns

I am trying to 'stagger sort' multiple columns, but am having some difficulties.
Ex.
Say A and B are lists of part no and C is data corresponding to column B. I have:
A B C
1 2 .
2 3 ,
4 4 ;
5 7 '
8 9 "

I want:
A B C
1 _ _
2 2 .
_ 3 ,
4 4 ;
5 _ _
_ 7 '
8 _ _
_ 9 "
(the _ are just supposed to be empty place holders, without them I have formatting issues)

Is there a 'quick' way to sort them this way?
I am attaching the actual file that I am working with.

Not clear.. can you please manually sort few of them in the attached.. or explain lil bit the logic..

Kay,

When you joined the forum recently you agreed to abide by the Forum Rules, but in haste I fear you might not have actually read them. Please stop and take a moment to read them now.

Specifically note rule #2 (do not hijack another thread) and rule #8 (do not crosspost the same question in multiple places). I have closed the hijack/crosspost you posted elsewhere. Please understand we all follow these rules for the benefit of all, as must you. Thanks.

(link above in the menu bar to read the rules)

I apologize for my misconduct, it was unintentional. I have now read the rules and will do my best to abide by them.

The LineEmUp macro on that other thread was custom designed to match rows with like value in ascending order. I've looked at your attachment and it doesn't seem to be that at all.

Your sample workbook only need 10-20 rows of data to be usable. With that, look at the data and make sure your sample workbook has two sheets in it, a BEFORE and AFTER. I'd think we'd be seeing duplicate values in columns A and B that are not aligned in BEFORE, and are now aligned in AFTER.

Assuming:

1) Data starts in row1
2) Columns A:C only are used

Try this on a copy of your data, it uses columns E:H to quickly make a unique match table:

Please Login or Register  to view this content.

Did that work for you?