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

Mythbuster 41 Reputation points
2021-11-17T14:09:44.047+00:00

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.

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,976 questions
No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Dave Patrick 330.7K Reputation points Microsoft MVP
    2021-11-17T14:12:41.403+00:00

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

    No comments