Forum Discussion
PDF table converted into Xlsx, merged every other row! HOW TO SEPERATE?
I converted a pdf table to a xlsx and when opening it, it combined every other row into a cell. How do i get each row separated? I did it once all manually to one but would like a faster route and a solution to this problem.
2 Replies
Did you try to import table from PDF by Power Query (aka Get & Transform)?
SergeiBaklan thank you, as much as I've used excel, I've always imported from pdf247.com. Is there a way that each page doesn't create its own sheet? I have 100+ pages and would like it all in 1 sheet.
