Forum Discussion
NoelGilling
Jun 19, 2020Copper Contributor
Hi! im really confused on how to sort these US patent numbers
So i need to sort from min to max the values of the classes of more than 2000 patents, so the patent number is un A1 and the rest of the class numbers are in B, C, D.... and so on. the problem is tha...
hynguyen
Jun 19, 2020Iron Contributor
NoelGilling Hi, it is not clear if you want to sort only a column or a combination of column here (and which columns should be included in the combination if so). Could you pick out some examples of the raw data and what are the desired sort result you wish to see so we could understand your logic before suggesting any solution.
NoelGilling
Jun 19, 2020Copper Contributor
hynguyen so this is what i need (ignore the colors, those are just to be clear) i want all the classes of patent numbers arranged from minor to max, like these examples, red means is not in the right position. So basically a want arrange horizontally the classes of each of the patent numbers, so when i do that with the sorting tool, the numbers dont arrange correctly as you can see in the example.