5:18
Zack Barresse
Love Excel, shiny new things, my family, gaming, and general cool stuff. Oh, and being awesome. #hashtagsmatter
Viewers will learn a basic data manipulation technique of unpivoting data in Power Query for Excel 2013 and the importance of using good data.
Video Steps
1. Start with data in a poor structure
2. Create a table on your data
3. Unpivot columns
4. Rename columns
5. Apply query and close editor
6. Summarize data in newly created table
0 Comments
Suggested Videos
This article series will show you how to utilise the Next Generation Cryptography (CNG) API from Microsoft for modern hashing and encrypting/decrypting in VBA.
In this part: Hashing.
A while back I wrote an article about the Power Query Editor and PowerBI (https://www.experts-exchange.com/articles/37938/PowerBI-and-the-Query-Editor-Save-time.html). I have realized that my coworkers primarily use Excel and So have changed the ar…
Suggested Courses
Next Video:Combining Excel's Take and Filter Functions