Forum Discussion
Azra_boost
Sep 15, 2020Copper Contributor
From rows to columns
Hi, I have a PDF database of contacts. When I copy and paste it in Excel, it all comes in one long column. However this includes in the actual database 5 columns : NAME FIRSTNAME MEDIANAME TYPE MAI...
Sep 15, 2020
Hi Azra_boost
Instead of copy and pasting the data into Excel you can use the Excel New PDF connector to connect you DATA and grab the information.
Below Blog link might be helpful for you
https://excelexciting.com/get-data-from-pdf-in-excel-with-power-query-pdf-connector/
Note that this is available only for (Office-365) users only.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official/Best Answer to help the other members find it more