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.
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
STEP 2: Now click on Data > From Table/Ranges > Add Column > Index Column
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.
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)
Now You extracted only names from the column.
STEP 5: Click on Inserted Modulo Option > Extract Previous > Name value anything like “Index Setup”
Here you have Split a Query into Two Parts in Power Query.