Prompt Details
Model
Chat - (gpt-5.4)
Token size
358
Example input
[USER_INPUT]: Combine multiple Excel files from a folder Clean and standardize data Remove duplicates Convert date column Aggregate total sales by region
Example output
let
Source = Folder.Files("C:\SalesData"),
FilteredFiles = Table.SelectRows(Source, each [Extension] = ".xlsx"),
Imported = Table.AddColumn(FilteredFiles, "Data", each Excel.Workbook([Content])),
Expanded = Table.ExpandTableColumn(Imported, "Data", {"Data"}),
Combined = Table.Combine(Expanded[Data]),
RemovedDuplicates = Table.Distinct(Combined),
ChangedTypes = Table.TransformColumnTypes(RemovedDuplicates, {{"Date", type date}, {"Region", type text}, {"SalesAmount", type number}}),
Grouped = Table.Group(ChangedTypes, {"Region"}, {{"Total Sales", each List.Sum([SalesAmount]), type number}})
in
Grouped
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
3
Views
GPT-5.4
Description
Generate clean, efficient, and ready-to-use Power Query (M code) for Excel in seconds. Perfect for analysts, freelancers, and business users who want to automate data cleaning and transformation tasks without writing complex formulas.
✅ Removes duplicates, errors, and null values
✅ Automates column transformations and formatting
✅ Merges, filters, and reshapes datasets
✅ Works with messy real-world Excel data
Just describe your data and desired output—get production-ready M code i
...more
Added 1 week ago
