Forum Discussion
Use Power Query to pick value from specific cells in multiple files
Hello all, I need some help here. I am trying to user PowerQuery to do some analysis. Basically, I have about 70,000 files that I want to copy elements from them....elements as in specific cells, c4...
Hi Anonymous ,
If you want to pick the same cells from each of your individual files, then check out my solution on this thread:
If you want to pick individual cells from each file differently, you could have a look at how I've done it in this thread:
https://community.powerbi.com/t5/Power-Query/Excel-formulas-in-Power-Query/m-p/2114211#M62325
where I've used references in curly braces and square brackets to reference specific row and column coordinates respectively:
Pete