Break out paragraphs in PDF via Power Query in excel

Hello,

attached is a workbook that is using power query to import a sample PDF contract. I am trying to find a way (either in power query or via excel formulas) to break out all the sections as they appear on the PDF, so in paragraph form. In column R on the SampleContract-Shuttle pdf sheet I have a concatenate formula, but that just is a join that works for sentences. I am looking for a formula or a way in power query to section off the PDF in paragraphs just like it is on the actual contract. Both files are attached. Anyone have idea? Thx

I don't think the task is doable with the current layout of the data received. Take a look at rows 9 and 32. Duplicates have been created, although they do not occur multiple times in the PDF document. There are more such duplicates in the received data.
This is a difficult task. I will admit that I have never come across a converter that fully reproduces the source document.
At the moment I am just working on reading PDF documents using VBA. Admittedly, I'm at the beginning of this road, but there is some hope in being able to retrieve the so-called envelope of each word (or word bounding box), i.e. the position of the words (or more precisely, the rectangles in which the text is written) on each page of the document. Knowing the position of the words, you can combine them into sentences and paragraphs. Unfortunately, you need Adobe Acrobat Pro to read the envelope. In the attachment I show the result of such a reading of your PDF document. After reading, the data were sorted to group them by the pages of the document and then by the positions of the top edges of the rectangles. The page numbers are counted from 0, not 1. Also note that the positioning of objects on the page starts at the bottom-left corner of the page, not at the top-left corner as in Excel. The "¶" sign is a graphic sign of moving to a new line. As you will be able to see by examining the attachment, it is not always the case that words are inserted in a logical order (as we see in the document). The order of insertion is reflected in the Idx column.

Artik

And it worked out quite well.
I changed the sorting order. Now Page, Bottom, Left.
As I mentioned I haven't found the perfect converter so far. And this one isn't either. Rows 72 and 73 should be in one paragraph.

Artik

I have decided to use MS power automate flows instead of power query to get the PDF data extractions, therefore am marking this thread as solved.