In Excel, we can use Power Query to read from different data sources. Then we can do things like append and merge. But after that, sometimes we want to put the appended table back into the data source. How can we do this?
For example,
I have 2 files, one.csv and two.xls
In my master.xls file, I have imported both of these files using Power Query then merged them together.
Now how do I export this merged table as one.csv (or two.xls)?
I can manually copy and paste, but I imagine Excel should have to data export tool for that?
Thanks!