Tag Archives: Text.Split

Trim like #Excel in #PowerQuery

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

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 , | 2 Comments