Category: Power Query Articles

How to Combine First and Last Name in Excel (4 Easy Ways)

Fill Down Blank Cells Until the Next Value in Excel (3 Easy Ways)

5 Easy Ways to Calculate Running Total in Excel (Cumulative Sum)

How to Get Month Name from Date in Excel (4 Easy Ways)

Merge Tables in Excel Using Power Query (Easy Step-by-Step Guide)

Combine Data From Multiple Worksheets into a Single Worksheet in Excel

How to Unpivot Data in Excel using Power Query (aka Get & Transform)

Combine Data from Multiple Workbooks in Excel (using Power Query)

Get a List of File Names from Folders & Sub-folders (using Power Query)