Grouped index columns

The pharmacy team has sent a new data file with all the medication information collected for each patient who visited the emergency department. It includes each PatientID, the types of medications they are using, and the total medications for each.

Your task will be to enhance this dataset by adding a grouped index medicationrankID to count unique medication types for each PatientID, sorted by top medication type by total medications.

If you lost progress, load the workbook 2_4_grouped_index_columns.xlsx from the Workbooks folder and launch the Power Query editor.