Hi, I'm looking for help extracting data that resides in a single cell into separate cells for each data point separated by a space with in the original 'merged' cell. That's the redux solution I have come up with from the overall problem, but I'll also address the bigger picture in case there is a more comprehensive solution.
I have mountains of pdf pages of data in a visual column/row format that I wish to convert to Excel in order to perform further analysis, however when exporting to Excel, Adobe is primarily separating by column and not by row. This is ok if I can figure out some other way to divide the column data into rows such that each piece of individual data resides in it's own cell, unless someone has an even more efficient solution to my overall PDF to Excel conversion problem. I have attached sample documents of both the source pdf and the extracted Excel cells. Each data set in my mountain is two pdf pages and the number of rows are not always consistent in each set. There are many formatting challenges that occur with the PDF to Excel conversion. I can work around them, but at minimum (see 'at minimum' tab in the Excel file) if I can learn how to take a single cell/column that contains many non-separated rows and separate the data to their individual cells, that would be most helpful! Thanks in advance for your consideration/solutions.