<

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x

Power Query in Excel

Posted on
7,777 Points
1,277 Views
5 Endorsements
Last Modified:
Experience Level: Beginner
5:20
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

5
Comment
0 Comments

Featured Post

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Join & Write a Comment

Know the 5 most critical benefits of Microsoft Office 365 Exchange online for business, enterprise, education, and students. Also, be aware of Office 365 Challenges and how to backup data safely.
Switching from G suite to Office 365? Here are the top 5 reasons you need know for G Suite to Office 365 migration, comparing all the possible factors of both Google Apps and Exchange Online.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month