Get & Transform Archives

5 Ways To Change Text Case In Excel

by John | Apr 30, 2019 | DAX, Functions, Power Pivot, Power Query, Tutorials | 0 |

Learn how to change text case between lower, upper and proper case in Excel using Excel functions, flash fill, power query, DAX and power pivot.

Bulk Find And Replace In Power Query

by John | Jan 28, 2019 | Get & Transform, Power Query | 9 |

Learn how to do a bulk find and replace in power query based on a list of values.

Replicate Excel’s TRIM Function In Power Query

by John | Jan 17, 2019 | Get & Transform, Power Query | 3 |

Learn how to build a custom query function in power query that will replicate Excel’s TRIM function.

Introduction To Power Query M Code

by John | Dec 23, 2018 | Get & Transform, Power Query | 9 |

Learn the basics of power query’s M code language with this complete guide to M code.

4 Ways to Remove Unwanted Space Characters

by John | Sep 27, 2018 | Functions, Power Query, Tutorials, VBA | 2 |

Learn how to remove unwanted space characters from text data in Excel using various methods.

Import XML Files into Excel

by John | Jul 15, 2018 | Get & Transform, Power Query | 7 |

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

25 Amazing Power Query Tips and Tricks

by John | Jun 11, 2018 | Get & Transform, Power Query, Tips & Tricks | 15 |

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.