Forum Discussion
Solved
How to import data from several excel sheets without unwanted rows/columns?
Hi All, I'm analysing data in Excel from multiple sheets that contain the same type of questionnaire data that I need to put together and analyse together. Each individual sheet has the required ...
ak8598 When you use a Folder query you should get the opportunity to edit the sample file that it uses for the rest of the files as well. You just need to edit this sample query to make sure it performs all of the operations necessary. You may want to pick a different file for this than the default.
Hi ak8598 ,
When you select the table in the navigator, select the tables with the following instead of selecting the sheets.
Or use the methods from the below link to remove blanks.
How to delete blank rows in Excel using Power Query to clean up your tables (spreadsheetweb.com)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.