Category: Get & Transform
Import XML Files into Excel
In this post we’ll take a look at how to import an XML file into Excel and turn it into a more human readable table format. Excel has support for XML files and it’s actually really easy to import and covert them to tables using Power Query
Read More
25 Amazing Power Query Tips and Tricks
Power query is amazing tool that allows you to import and transform data with ease and helps to create repeatable and robust procedures with your data. Here are some tips and tricks to help you get the most out Power Query.
Read More
Create Grouped Serial Numbers with Power Query
Learn how to add grouped serial numbers to your data using Power Query.
Read More
Adding Metadata to a Report with Power Query
This post will show you how to import the metadata from a CSV file into our report data with power query (also called Get & Transform).
Read More
Transform a Column to a Table with Power Query
Use power query to transform a single column into a table.
Read More
How To Get All Sheet Names From All Workbooks In A Folder
It’s a task I’ve had to do before. Get a list of all the sheet names in a workbook...
Read More
