A 1 FirstPhase 2 SecondPhase 3 ThirdPhase 4 FourthPhase**Table 2**
A B 1 Item1 FirstPhase 2 Item4 FourthPhase 3 Item2 SecondPhase 4 Item3 ThirdPhaseThe result I want to achieve after sorting is:
A B 1 Item1 FirstPhase 2 Item2 SecondPhase 3 Item3 ThirdPhase 4 Item4 FourthPhaseHow can I sort the second table by column `B` according to the order of column `A` in the first table?
You shouldn't have set this to 'Community Wiki', you probably would have got more input. I'll see what I can figure out.