Excel Power Query Archives

How to Create Cross Join in Excel (3 Simple Ways)

Feb 2, 2023 Excel Power Query

A Cross Join combines each row from the first table with each row of the second table. Cross Join returns all the possible combinations of two ...

How to Perform Left Outer Join in Excel (2 Easy Methods)

Jan 3, 2023 Excel Power Query

This tutorial will demonstrate how to perform left outer join in Excel. When we are dealing with many data tables that represent information about a ...

How to Create Full Outer Join in Excel (2 Ideal Examples)

Dec 27, 2022 Excel Power Query

Merging or joining columns is a very common requirement among Excel users. But things get really difficult when the dataset is large and has ...

How to Perform Outer Join in Excel (2 Easy Ways)

Feb 8, 2023 Excel Power Query

Unquestionably, Microsoft Excel excels at crunching numbers! Now, this means that you can merge datasets and perform tedious calculations in the ...

How to Inner Join in Excel (2 Easy Methods)

Feb 7, 2023 Excel Power Query

An inner join is one of the join types offered in Power Query's Merge dialog box. An inner join only pulls matched rows of both tables. In this ...

Compare Two Tables with Power Query in Excel (2 Examples)

Feb 8, 2023 Excel Power Query

When working with tables, it is a frequent need for us to compare two tables to each other if their values are the same or different or can be linked ...

How to Combine Two Tables Using Power Query in Excel

Feb 7, 2023 Excel Power Query

Sometimes, you need to combine two tables in Excel. You can do it manually but that takes a lot of valuable time. Instead of doing this manually, you ...

Dealing with Tables with Changing Headers in Power Query

Feb 12, 2023 Excel Power Query

As in real time it happens a lot, we tend to update our original data source a lot, during that period, we may alter the column Header a bit inside ...

How to Split Column in Excel Power Query (5 Easy Methods)

Mar 5, 2023 Excel Pivot Table

While working with large Microsoft Excel, sometimes we need to split columns using a power query. Splitting columns by using the power query is an ...

Excel Power Query: Transpose Rows to Columns (Step-by-Step Guide)

Feb 23, 2023 Excel Power Query 1

The Power Query in Excel makes the transformation from rows into columns very handy. In this article, you will learn to transpose rows to columns ...

How to Calculate Running Total by Group Using Excel Power Query

Feb 28, 2023 Excel Power Query 5

Running totals simply means the cumulative sum of a sequence of values. The application of calculating running total is quite significant for ...

How to Remove Spaces in Excel: With Formula, VBA & Power Query

Feb 19, 2023 Excel Formulas

In Microsoft Excel, there are several effective methods available to remove all sorts of unwanted spaces. You’ll get to know all possible and ...

How to Pull Data from Multiple Worksheets in Excel (4 Quick Ways)

Mar 19, 2023 Excel Power Query

While working in Excel, we often have to work with a lot of worksheets in a workbook. Today I will be showing how you can pull data from multiple ...

How to Merge Excel Worksheets Without Copying and Pasting

Feb 27, 2023 Advanced Excel 2

The problem that occurs while copying different elements of a worksheet into another worksheet is that you may not get the actual formatting of the ...