Forum Discussion
Solved
editor power query
Hello guys please i need help i have a PDF file with 568 page each page contient a table. first i convert it into excel file and i didn't get what i want. second i used functionality in excel named...
safwen Take the screenshot in your message (see picture) as a starting point.
Klick on the button of the Kind column. Select only "Table" and press OK.
Then in the Data column, press the button with the arrows.
Should look something like this:
Press "Load more" if it show. Now uncheck the box "Use original......" and OK.
That should give you one large table of all the tables combined.
safwen In the Navigator screen you should enable "Select multiple items". That will allow you to select all the tables you need/want.
i select the first line so i get all the tables as one source