<

Power Query in Excel

Posted on
7,859 Points
1,359 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
0 Comments

Featured Post

CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

Suggested Videos

Enroll in these five web development courses: RESTful Services: Data, JAX-RS and Jersey, RESTful Services: Fundamentals, Selenium Fundamentals, Bootstrap 3.1: Fundamentals, and Perl Fundamentals. Then learn to perform data analysis in Microsoft Exce…
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month