If you've ever gotten a report, it's already been summarized with a specific format with a set of column or row headers (or maybe multiple layers of column or row headers). You'd think that it would take some time with multiple copy and paste steps to get the report view back into a table. With Power Query, you can revert this report back into a proper table so you can do some further analysis in just a few steps.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.