Perform transformations on a table in each row

[Attrazoine]

I have many pdf files within a folder. My first source is Folder.Contents on the folder which results in a column that has tables containing the pdf data. 

My problem is that each table needs transposed before it is combined with the other ones. Is there a way I can send every row into a series of steps and then append it to the main table?

My queries are on my GFE so I will do my best to provide explanations, but I cannot get screenshots of my queries or steps.

Thank you in advance,

Kevin

[Anonymous · Accepted solution]

Hi @Attrazoine 

Maybe you can refer to the following links:

Combine multiple files in Power query editor - Microsoft Power BI Community

Power Query: Combine Files from Multiple Folders - Enterprise DNA

Best Regards!

Yolo Zhu

^{If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.}

[Attrazoine]

Thank you Yolo! That is perfect. I spent an hour trying to Google what I wanted to no avail. This is greatly appreciated.