Forum Discussion

123abc's avatar
123abc
Community Champion
1 year ago
Solved

Mange Data in Excel with Power Query

Hi Experts:   I have a Gulfoods Catalogue  i wants to extrract the following Informaiton from it and wants to organizae it in excel 4 columns parallely like:   1.Comany Name 2.Tel 3.Email 4.We...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • BeaBF's avatar
    BeaBF
    1 year ago

    123abc Thank you so much for your kind words, I'm happy I was able to help you! Please accept the message above with the code as the solution, to assist other users as well!
    Regarding point 5, here's the explanation.

     

    I've used a M code that filters the table `"Added Index"` using `Table.SelectRows`, keeping only rows where:

    1. `Column1` contains "Tel:", "Email:", or "Website:".
    2. `Column1` is fully uppercase and not empty (`Text.Upper([Column1]) = [Column1] and [Column1] <> ""`).
    3. If none of the above applies, the row is ignored (`null`).

     

    BBF

123abc's avatar
123abc
Community Champion
1 year ago

Thank You Very Much .. Please let me check.

123abc's avatar
123abc
Community Champion
1 year ago

Thank You so much this has resolved now. I am bit confused on a little applied step # 5 Filtered Rows, after step # 4 in applied steps Added index, how you added this step # 5, I mean are you using add Column + Custom Column and adding Table.SelecRow(.....) M Function or using any other approach bcz i just stuck here ...! and onward, all steps i have understad wtih the help and guidence of you kind support.  Thank You Very Much again for your kind support.

 

Regards 

Ali Abbas