title: Apply multiple filters of same column for same ID in excel
body: <p>Need help. I have an excel sheet with the first column containing patient IDS. I have other columns containing gene ids. the first column contains multiple rows for one patient with each row having the patient id and gene data. I want to filter patients with X gene mutation first and also find out what other gene mutations the same patient is having. I cannot do this individually as I have 100 k records. any method to do this in excel, power BI or python</p>