PDF table converted into Xlsx, merged every other row! HOW TO SEPERATE?

New Contributor

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.  Mortgage Excel Help.jpg 

2 Replies


Did you try to import table from PDF by Power Query (aka Get & Transform)?

@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.