Forum Discussion
Remove Columns From Multiple Tables at the Same Time
Hi, Brand new to Power Query Excel. Actually stumbled accross it when i searched for how to import a pdf into Excel. Here is my issue. I have a pdf document that has about 180 pages. On each page...
Hi mussaenda
Thanks for your reply. I really know little of this so let me try to explain what I am trying to do.
I have a PDF that contain multiple pages. Each page relates to an organisation and each organisation has a table that lists contacts and email address. I need name and email address colums only from each table. Once I have that as a list in excel, I will be sending an email - simply copy and paste the email address into my email client in the 'to' box. I am not trying to do anything special. I converted the PDF to excel by getting data in the following method - Data > Get Data > From File > From PDF. This process is creating 180 tables because there are 180 tables in the PDF.