Issue sorting column by another column

Hi , You are trying to sort the data in 'ExpiryAnalysis_1' based on the values in 'Order_'. 

• Uniqueness Requirement: For the sorting operation to work, each value in 'ExpiryAnalysis_1' should correspond to a single, unique value in 'Order_'. However, in your data, it seems that there are instances where a single value in 'ExpiryAnalysis_1' is associated with multiple different values in 'Order_'.

• Conflict: The presence of multiple 'Order_' values for the same 'ExpiryAnalysis_1' value creates a conflict, preventing the sort operation from being performed as intende

   

   

  To resolve this issue, you need to ensure that each value in 'ExpiryAnalysis_1' has a unique corresponding value in 'Order_'. Here are some ways to do that:

  1. Select a Different Column for Sorting: If another column in your dataset has a unique value for each 'ExpiryAnalysis_1' entry, you can use that column instead.

  2. Aggregate 'Order_' Values: Combine the multiple 'Order_' values into a single value for each 'ExpiryAnalysis_1'. For example, you might take the average, maximum, or sum of the 'Order_' values.

      

      

     If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
     If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

cottrera