Power Query - Combine rows into one cell

[egspen2]

I have a PDF with what appears to be a pretty clean table that I'm having issues importing cleanly into PQ / Excel. Below is a snippet of the table (it covers ~20 pages of a PDF):

When I go to import into PQ, I run into one of two issues:
1) I import the table object and everything except the first column (column with the vehicle info) imports cleanly (the vehicle column is not coming into PQ at all).
2) I import the page object and everything including the vehicle column comes in but each vehicle is being split across four rows:

Option 2 feels like my best starting point but the issue I'm running into is how to get the four rows for each vehicle into one row / cell. For Option 1, I do not know why just one of the columns from the PDF table isn't coming in.

 

[alansidman]

Your first picture appears to be the PDF. It would helpful if you showed it as it comes into PQ. In this manner, we may be able to compare the two and offer valid suggestions. Also, it would be greatly beneficial if you reloaded both using XL2BB so that we don't have to guess at the formatting and also have to reenter your data to test our solutions Help us to help you by making it easy on us. Afterall, we are volunteers with limited time of our own.

 

[egspen2]

Thank you. The second screenshot was a view of how the same page of the PDF (from the first screenshot) came into PQ. Will try again with XL2BB.

 

[alansidman]

Ok. Understand. What do you want the end result to look like. It appears that the data is coming into PQ correctly. Now the issue is. "What is the end result to look like?"