Excel Tips
February 25, 2020
YouTuber Rico S took a completely different approach. His table is generated by a single dynamic array formula.
Power Query: The World of Bill Szysz »
February 25, 2020
After reviewing 29 different entries, I am declaring the winner to be Bill Szysz! Bill is one of those people who are comfortable typing queries without using the Power Query interface. He writes, “This can be done in dozens of ways. I am sending you four.”
Power Query: Beyond the User Interface: Table.Split and More »
February 25, 2020
While the Power Query interface is very powerful, those who can go beyond the interface have super powers.
Excel MVPs Attack the Data Cleansing Problem in Power Query »
February 25, 2020
Excel MVP Oz Du Soleil from Excel on Fire channel on YouTube mentioned Brazilian Bull Rider Kaique Pachecho. Oz was the first person to notice that I went the slow way to add the four quarters.
February 25, 2020
One of the problems with my solution is that the final sequence of the categories did not necessarily match the original sequence of the columns. I realized this at the very end of my video, and since it was not particularly important, I did not worry about it.
Power Query: Isolating the Rows that represent Quarters »
February 25, 2020
There is a point in each solution where you need to figure out which rows contain employee names and which rows contain quarters.
Power Query: Delete this, Delete those, or delete nothing? »
February 25, 2020
I am having a great time going through the 29 different solutions to the Data Cleansing challenge. In my solution, and in many solutions, I came down to the point where I wanted to delete the subtotal row.
Power Query: Dealing with Multiple Identical Headers »
February 25, 2020
In my original data shaping problem, I ran into a problem very early in the process. The incoming data was going to have many columns with a heading of Q1.
Power Query: Using Else If Clauses in Conditional Columns »
February 25, 2020
In my solution to reshaping the data, I wanted a way to see if a column contained an employee name or a value such as Q1, Q2, Q3, Q4. I assumed that no one would have a name with 2 characters, and so I added a column to calculate the length of the text in the column.