Forum Discussion

fahadarshad's avatar
fahadarshad
Helper I
6 years ago
Solved

How to get specific rows from multiple excel files

Hello everyone   I have multiple excel files, with multiple excel sheets. What I intend to do is to go in every sheet of every excel file in a particular folder and only pick out the rows from thos...
Need Help
JohnThomas's avatar
JohnThomas
Helper II
6 years ago

Can you upload some sample workbooks?

fahadarshad's avatar
fahadarshad
Helper I
6 years ago

Here you go,

 

I just need the rows that have shop names, nothing before of after that.

  • JohnThomas's avatar
    JohnThomas
    Helper II
    6 years ago

    This seems rather simple.  Can't you just filter your column to anything with the word "Shop" or "List" in it?  Or are the Shop 1, Shop 2, etc. realy some other names?

     

    = Table.SelectRows(#"Previous Step", each Text.Contains([ShopList], "Shop") or Text.Contains([ShopList], "List"))

     

    Is the data in a table, or just raw data in worksheets?

     

    Is there a column header?  Are you needing to know how to filter the list, or is the real problem combining all the sheets and files together into one table with all shops?

     

    It will help structure a good solution to your problem if your sample data is as close to real as you can get it.