Power Query is a very useful tool from Microsoft. It is available from Excel 2010 onwards. One can perform a lot of complex steps using Power Query which used to quite difficult through conventional Excel formulas & features. Learn how to do Nested Ifs through Power Query conditional columns.
Download the sample file from: https://www.vivran.in/downloads
File Name: Sample Data 2