You have multiple worksheets or tab to combine? It's easy if its just 1 or 2. It's even not that bad if you have to do some kind of transformation like to unpivot the table. However if you have to do a LOT of tables or do it on a recurring basis, then it's becomes a hassle. Power Query can rescue you from the mundane and laborious process of manually doing these steps.
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.