Process Data Using Modulo in Power Query
Excel in Office 365 has a new set of a feature known as Get & Transform. It provides a platform to perform a series of steps to help you to transform your excel data.
Powerful Power Query editor comes with a standard option which includes MODULO which makes it easier to split column and process data accordingly.
You can also browse our Power Query Tutorial Catalog here.
NOTE 1: We will be using data from: How to Split a Query into Two Parts in Power Query?
NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.
To Continue Please Follow the steps from 1 to 5 from – How to Split a Query into Two Parts in Power Query?
Process data from the split query, we need to save and close the data we want to process. in power query editor.
STEP 6: In Power Query Editor,
Select Insterted Module under applied steps > go to home option > Click on Save and Load to process data.
You will get your names data in workbook like below;