Split a Query into Two Parts Using 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. There is one cool step which will help you to split a query into two parts to make it easy to read and understand.

Sometimes you must want to reuse an existing query because you don’t want to redo all the steps, but you don’t know how to do it so, this tutorial will be helpful for you. 

NOTE 1: You can create random excel workbook online here for practice purposes as I did in this tutorial.

NOTE 2: If You use Microsoft Excel Prior to 2016 Version, then You Need to download Power Query Separately.

Split a Query

Previously In power Query: How to Use Power Query to Copy and Paste Queries across Workbooks?

Now we are going to split this query into two parts. We will mention all the steps below:

STEP 1: Insert a table in your existing workbook/sheet

Click on Insert > Table

Split a Query2

STEP 2: Now click on Data > From Table/Ranges > Add Column > Index Column

Split a Query3

STEP 3: Now Select Index Column in Power Query editor > Add Column Section > Click On Standard > Modulo

As you can see our rows are repeating 3 times, Therefore add 3 in Modulo popup value option.

Split a Query4

As you can see names are appearing in value (2) on every modulo column.

STEP 4: Therefore, Use Modulo Drop down menu > Click On Value (2)

Split a Query5

Now You extracted only names from the column.

STEP 5: Click on Inserted Modulo Option > Extract Previous > Name value anything like “Index Setup”

Split a Query6

Here you have Split a Query into Two Parts in Power Query.

NEXT: Continue With This tutorial to learn How to Process Data Using Modulo in Power Query