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.

Process Data Using Modulo

You will get your names data in workbook like below;

Process Data Using Modulo Cover