How can I select rows based on multiple conditions for the same ID?
Hello, I need assistance in cleaning up some data. The data in the table contain multiple IDs, dates, and categories. I am interested in IDs with category 1 and 2, or 1 and 2 and 3, or 1 and 3, while retaining only the entries with the maximum date for each category. Could you please provide the best script for this solution? Thank you!IDcategorydatecostAcostBcostCcostD111/21/16500003000500111/21/...