Tag Archives: Unpivot column

Unpivot Columns with #Excel #PowerQuery

Posted on September 9, 2023 by MF

It is so common that we deal with crosstabs in Excel. It is good for displaying summarized data. However, if you need to further analyze the data, especially with PivotTable, you will find a crosstab not the right layout. What … Continue reading →

Rate this:

Posted in Power Query | Tagged | Leave a comment

Combine all visible worksheets from multiple #Excel files in a folder

Posted on August 11, 2020 by MF

It is a common task for us to combine all worksheets in a workbook. It could be a time consuming task without Power Query. With Power Query, it’s piece of cake. 😁 Wait? What about if you want to combine … Continue reading →

Rate this:

Posted in Power Query | Tagged , , , | Leave a comment

#Excel Power Query solves a real life problem – Who eats what?

Posted on January 18, 2020 by MF

Interesting application of Power Query for real life problem – See how to transform table into different layout using Power Query I came across this Power Query Challenge from Computergaga and I found it really interesting as it seems that … Continue reading →

Rate this:

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