Excel's built-in tool for importing, cleaning, and reshaping data with repeatable, refreshable steps.
Try it with AIPower Query (Get & Transform) connects to files, databases, and the web, then records every cleaning step — split columns, remove rows, merge tables — so you can refresh the whole pipeline with one click when source data updates.
No — Power Query cleans and shapes the data; pivot tables summarize it. They're often used together.