How would you export data sets contained in a Word document with variable separation of data elements within each data set to regular rows and columns? When I save to a .txt file with no formatting, it appears the data sets are entered line by line in sequence until the last two elements, which are separated possibly by a tab, with a final line feed to the next data set. If the next to last element expands to butt up against and hides the tab division in the text document, these last two elements seem concantenated with no separation.
Perhaps I can save as a formatted text document, which would preserve the tab, then replace all tabs with a line feed. Then I can import to Excel using import wizard, if it recognizes a line feed as a field separation, resulting in one long row of elements, which your excellent macro would transpose using number of rows converted to columns, repeating for all data sets.
When running OCR for handwriting, as in lab notes, I convert the elements into data sets for an Excel spreadsheet to use in data analysis, but this requires verifying correct OCR.
Voice Recognition would be perhaps faster, if Excel had a consistent handle for commands to advance to next cell. Perhaps there is a macro that works with Voice to Data when inserting a series of data into a spreadsheet without having to look at the screen and interrupt reading the series to force advancing to the next cell.