Tag Archives: Text.Split

Trim like #Excel in #PowerQuery

Posted on May 9, 2022 by MF

In Power Query, there are some functions that are very similar to Excel, which you expect the same results from them. However, it may not be the case because they indeed perform differently. TRIM is one of them. TRIM is … Continue reading →

Rate this:

Posted in Power Query | Tagged , , , , | 6 Comments

Rename column names in a dynamic way with #Excel #PowerQuery

Posted on April 18, 2021 by MF

Situation: We have many different tables to be appended. It should be a simple task with Power Query. You may refer to my blogpost here for the basic of appending tables with Power Query. Nevertheless, life could be challenging in … Continue reading →

Rate this:

Posted in Power Query | Tagged , | 9 Comments