[Affiliate]
Blog Stats
- 3,316,174 hits
-
Join 3,247 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"
- F3 - It is about Naming...
- Filter a list of items from a long long list
- Calculate number of a specific day between two dates
- Identify missing files in a folder with Power Query
- Quickly delete/hide records (rows) with Strikethrough format by using Find and a couple of simple techniques.
- Sequential number for visible rows only
- Interactive Chart is not difficult to make - Part 1/3
- Paste Special – Linked Picture (aka “Camera” in earlier versions of Excel)
- Add conditional columns with #Excel Power Query
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 