As shown in figure, I want to G column names in pinyin to sort, could you tell me how to achieve the great god?
For example, is now "at the beginning of all ga, gura, old ancient barak, fu zhong, WuSu)",
Early after sorting should be "gura, ga, fu zhong, old ancient barak, WuSu)",

Now my idea is to separate the G column demolition H, I, J, K, L, a few columns, and then sort by line in the excel, and then merge back,
But there is a problem, according to the special order when no problem, but I'd like to order more when I will be based on the results of the first line sort, make the other all the columns and the column order of the first line, and can't reach each row column sorting alone,
Because of large amount of data, if one line manually selected click sort workload is too big, so please look great god, is there any function can be used,

CodePudding user response:

http://club.excelhome.net/thread-594824-1-1.html did sort part seems to be similar, but I also didn't see understand