Forum Discussion
Solved
Pulling data from multiple pdf forms, into workable format for PBI/PQ?
Hi all, I have a set of completed pdf forms from which I need to extract the data and generate some analysis. I have used acrobat's "merge to excel" function, which results in a single sheet wi...
Hi lizlizliz ,
Data sample:
1.Get data from Excel
2.Choose Transform Data to go into Power Query dialog.
3.Click Column1 ,then choose "Unpivot other columns"
4. Below is the final output after changing column names
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
It sounds like you're looking for Unpivot. Try searching for this and you should find a number of helpful tutorials.
One other tip: you can use the Folder connector to connect to the PDF files, transform them using one of them as an example, apply the example file transformations to all the files, and then combine the results together into a single table.