In this short introduction to Power Query, I’ll show you a problem that requires some fancy hoop-jumping to manage, unless you use Power Query. If you think the only way to get the results you need is to use complex formulas or even VBA code, take a step back and think, Can I do this in Power Query instead? Often, the answer will be yes. Once data is in Power Query, you can analyze and manipulate that data quickly using specialized tools. Using Power Query, you can load data from several different sources, including the active workbook. If that describes you, definitely review Excel 2016’s Power Query (or Get & Transform). For more info, visit our Terms of Use page.Īnalyzing data often means spending more time getting and cleaning up data than analyzing it. This may influence how and where their products appear on our site, but vendors cannot pay to influence the content of our reviews. We may be compensated by vendors who appear on this page through methods such as affiliate links or sponsored partnerships. Have a complex Excel problem? Power Query to the rescue! A super easy way to generate new records from multi-value columns using Excel Power Query
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |