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 form. When I import the data to excel all the data is across on one row (screenshot below-workbook 1).
I am trying to get the data to appear across multiple rows as shown in screenshot 2. I will have to do this for multiple forms daily (and there are 45 “rows” of data per form so I am trying to have a template where I could add in the data somehow or look it up and its added in the way I need it to be in.
Can you provide any insight on how I can accomplish this:
Workbook 1 – Data from PDF form:
Workbook 2 – What I want it to look like:
Thanks!
3 Replies
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.
