1010data interview question

Another work will be shared and asked how to solve that particular problem using MS Excel.