4 ms·
You might want to try out Power Query (get & transform). Step-by-step repeatable transformations where the UI records steps and writes code in the background.
by Hjfrf 5y ago
You might want to try out Power Query (get & transform).
Step-by-step repeatable transformations where the UI records steps and writes code in the background.
Almost exactly what you're talking about, and comes out-of-the-box in the last few versions.
- cmsonger 5y agoCool! Next time I'm opening up excel, I'll give it a look.
- Closi 5y agoAlso DAX and power pivot - if you think excel doesn’t have the features to reuse data sets I think you will be pleasantly surprised! This works alongside power query to create a relational data model from everything you import.