[Affiliate]
Blog Stats
- 3,266,378 hits
-
Join 3,244 other subscribers
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Rename column names in a dynamic way with #Excel #PowerQuery
- Show number in thousand (k) or in million (M) by using custom format
- Perform VLOOKUP with 2 lookup values
- Highlight weekends and holidays using Conditional Formatting in #Excel
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- How to put the Date Modified info on #Excel worksheet using #PowerQuery
- Insert blank columns to table in #PowerBI Desktop
- #Excel Add current selection to filter. What it does?
- How to sort bar chart in descending order?
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Unpivot column
Unpivot Columns with #Excel #PowerQuery
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
Combine all visible worksheets from multiple #Excel files in a folder
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
Posted in Power Query
Tagged Combine Workbook, Invoke Custom Function, Remove Top Rows, Unpivot column
Leave a comment
#Excel Power Query solves a real life problem – Who eats what?
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
Posted in Power Query
Tagged Conditional Column, Demote Headers, Merge Query, Pivot Column, Transpose Table, Unpivot column
7 Comments
wmfexcel 