Forum Discussion
Rearranging Data in Excel from PDF Form
I was wondering if any of you could possibly help me as I have been researching it online and can’t figure out a solution and I use excel at its basic functionality. I am collecting data in a pdf...
It could be done by Power Query if you consider it as an option. Query source, unpivot all columns, split first column to drop numbers off, group by it without aggregation and taking only values as lists, create resulting Table.FromColumns().
SergeiBaklan Thank you so much. I will look into it as I have never used Power Query before.
If you provide sample file without sensitive information, but structured as actual data, it'll be easier to illustrate on the sample.
