Power Query: Grouping Data based on Color of the font or other ways

Question

Hi Experts

The raw data in pdf has a Header with 10s of listings under each Header and about 10000 headers.
I have only office 16 professional and cannot read PDF so I copied it to a .xls file.

Example (sorry silly one!)
Purchase Order
Customer
Bill
receipt

Address
Door / Apt #
Street
City
State
Zip

etc long list

Now when I extract to .xls using copy and paste, I get the font but my challenge is the following

I need to Create a Power Pivot for each of the Header so I get the elements associated.
Example: When I select Purchase Order, I must get a listing of
"Customer
Bill
receipt "

one way is to add a column with a flash fill of associated Header but How can I do it in Power Query based on Font ?

Or any other best ways you advise would be appreciated.

Answer 1

Power query is not currently supported here on Q&A. The product group for Power Query actively monitors questions over at
https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services

--please don't forget to Accept as answer if the reply is helpful--