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