Forum Discussion
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...
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
