Challenge No. 3: Extract all possible combinations of ID and result in the right-side table.
Solved using:Excel (BYROW, COUNTA, DROP), Power Query (List.Transform), Python, and Python in Excel.
SORTBY
Sorts an array based on the values in another array in Excel.