Courses / Power Query (Get & Transform)
6. Creating a Power Query from an Excel table or range
How to create a new Power Query query by selecting an Excel table or range.
Power Query M (Excel)
Creating a Power Query from an Excel table or range
A Power Query created from an Excel table/range imports that table's data into Power Query so you can transform it with M.
"I want to clean up this Excel table once and reuse the steps whenever the table changes."
Select an Excel table (or a named range) and choose "From Table/Range" to generate a Power Query whose source is a reference to that table/range; Power Query then lets you apply transformations and refresh the results.
"I want to clean up this Excel table once and reuse the steps whenever the table changes."
Select an Excel table (or a named range) and choose "From Table/Range" to generate a Power Query whose source is a reference to that table/range; Power Query then lets you apply transformations and refresh the results.