Power Query - Creating List from PDF

Dear Sir/Madam

I was wondering if could help on the attached request. Thank you in advance.PQ Help 1.docx (70.9 KB) PQ Help 1.docx (70.9 KB)

Hi @Obydur,

  1. Duplicate your Query
  2. In the first Query keep the column pairs you need
  3. In the second Query keep the other column pairs you need
  4. Check that the column order is the same
  5. Append both Querys back together
  6. Transpose

Think that should do it, otherwise please provide a small sample - thanks.
I hope this is helpful.

1 Like

In future please add details of you question into the forum thread. Thanks

Thanks for posting your question @Obydur. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

You can use below Power Query . Also attached excel for your reference with dummy data.

    Source = Excel.CurrentWorkbook(){[Name="DATA"]}[Content],
    Data1 = Table.SelectColumns(Source ,{"Column1", "Column2"}),
    Data2 = Table.SelectColumns(Source ,{"Column3", "Column4"}),
    Data2_RenamedColumns = Table.RenameColumns(Data2,{{"Column3", "Column1"}, {"Column4", "Column2"}}),
    FullData = Table.Combine({Data1, Data2_RenamedColumns}),
    #"Transposed Table" = Table.Transpose(FullData),
    #"Promoted Headers" = Table.PromoteHeaders(#"Transposed Table", [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"A", type text}, {"B", type text}, {"C", type text}, {"D", type text}, {"E", type text}, {"F", type text}, {"G", type text}, {"H", type text}})
    #"Changed Type"

Create Header.xlsx (13.6 KB)

Hi @Obydur, did the response provided by @Melissa and @MK3010 help you solve your query? If not, how far did you get and what kind of help you need further? If yes, kindly mark the thread as solved. Thanks!

Hi @Obydur, we’ve noticed that no response has been received from you since posting the query on the 2nd of Sept. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!