Blog Stats
- 2,382,796 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"
- When unhide row doesn't work...
- Show number in thousand (k) or in million (M) by using custom format
- Filter a list of items from a long long list
- Perform VLOOKUP with 2 lookup values
- 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?
- Repeat all item labels in Pivot Table (aka Fill in the blanks please)
- Dropdown calendar in Excel
My YouTube Channel
My Facebook page
- My Tweets
Tag Archives: Append Query
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
Power Query Challenge β Joining two tables fully (Part 2)
Append Queries + Group By = Another alternative for a better Full Join In the previous post, we explored an alternative way to perform FULL OUTER JOIN with Left Outer Join + Right Anti Join, followed by Append Queries in … Continue reading
Power Query Challenge – Joining two tables fully
Left Outer + Right Anti = A better Full Join A sample file is available below. If you prefer reading to watching, please continue to read this post. The situation: I have two tables.Β One is Sales Table; One is … Continue reading
No more Copy and Paste to combine tables with #PowerQuery
Basic of Append Query in #PowerQuery With no doubt, combining multiple tables (mostly on different worksheets, or even in different files) into a single “master” table for further analyses is one of the most tedious tasks we deal with Excel … Continue reading
Maintain a price book in #Excel with #PowerQuery
Feel the Power (Query) This is my first post devoting to my recent love for Excel – Power Query. Β π First, let me make myself clear.Β I am still learning Power Query (indeed I am still learning Excel too).Β The … Continue reading