Forum Discussion
how to import and manipulate data from a report into a master sheet?
Hi all, production produces reports per team and we are looking to do some analysis with the data, what i would like to do is get the report, add it as a sheet into a master excel where some...
Riny_van_Eekelen thanks for the help, I don't know what power query is but the site you linked looks like a good start, and doesn't seem overly complicated. I'll have a look and give it a try,
Cheers
ju2k2 Just noted that you uploaded an XLS file. PQ requires XLSX files. Have attached a file, based on yours, including a PQ solution.