Blog Stats
- 2,427,510 hits
- Follow wmfexcel on WordPress.com
Search wmfexcel
Want Google to translate this page?
-
Recent Posts
Top Posts & Pages
- How to sort bar chart in descending order?
- Date Formats - A trick to format date with "st", "nd", "rd", "th"
- Show number in thousand (k) or in million (M) by using custom format
- When unhide row doesn't work...
- Filter a list of items from a long long list
- Perform VLOOKUP with 2 lookup values
- Dropdown calendar in Excel
- Insert a text string into a specific position of another text string in #Excel
- Open an embedded Excel file during a slide show in PowerPoint?
- How to lookup an image in #Excel
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Combine Workbook
Combine files of (slightly) different layouts in a folder with Power Query in #Excel
Part 2 β What if we have inconsistent table structures across files? Note: this is a long post. π This is the continuation of previous post. Suggest you read that post first if you are new to Power Query. Moreover … Continue reading
Combine files in a folder with Power Query in #Excel
Note: This is a long post… π Part 1 – What Power Query does for us in the process? If you know about Power Query, you should know that combining files in a folder is a powerful yet simple task … 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