Importing folder of multiple PDF files where table needs to be "transposed"

[drac6ir28]

Hello,

I'm having an issue importing multiple pdf files in a folder. Each pdf files contains a "sideways" table where the header is on the left of the table and the information is on the right.

No issue when importing a single pdf and using transpose but cannot get it working when using multiple pdfs.

E.g. Example PDF file content in each PDF:

Date:	2021/09/21
Sequence No:	12
Amount: 2300	2300
Description:	Sample Text
Remarks:	Sample Text

 
End result should be a single table containing information from all PDFs:

Date:	Sequence No:	Amount	Description	Remarks
2021/09/21	12	2300	Sample Text	Sample Text
2021/09/27	14	3750	Sample Text	Sample Text
2021/09/27	16	1230	Sample Text	Sample Text

Thank you for any suggestions.

[drac6ir28]

Thank you. It's working perfectly.

[Syndicate_Admin]

Since you made it, I have the same problem!!!

Best regards!!!

[lbendlin · Accepted solution]

write a custom function (or put it inline) that unpivots the table extracted from each PDF  before you combine the results.

If you can provide a couple sample PDFs we can show the required Power Query.