Excel's data import and transformation engine (Get & Transform).
Definition
Connect to files, databases, and web sources, then clean and shape the data with repeatable steps. Recorded steps re-run on refresh, which is ideal for monthly reports.
Excel glossary definition
Excel's data import and transformation engine (Get & Transform).
Connect to files, databases, and web sources, then clean and shape the data with repeatable steps. Recorded steps re-run on refresh, which is ideal for monthly reports.