<

Power Query in Excel

Posted on
7,892 Points
1,392 Views
5 Endorsements
Last Modified:
Published
Experience Level: Beginner
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

5
0 Comments
The Indian number format for currency has groups of two and three digits. The native Format function of VBA cannot handle this if Windows is set for a Western localisation. Thus, a custom method must be applied. Here it will be shown how to use dyna…
This article showcases how to fix basic cloud storage and sync errors in OneDrive for Business on primarily Windows OS workstations, but some of the tips and troubleshooting steps could be easily applied to OneDrive - Personal usage (non-work relate…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month