Dec 26 2021 01:17 PM
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.
Dec 26 2021 01:58 PM
Did you try to import table from PDF by Power Query (aka Get & Transform)?
Dec 26 2021 02:35 PM
@Sergei Baklan 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.