Take rows of text and move to into a new column, each column easily identified

Hi Everyone!

I need help with either a macro or formula that takes several rows of information and creates a new column. In the lines, I know where I want the new columns to start, but not sure how to best approach. Unfortunately the vendor we got the information from doesn't allow us to easily change the .txt to a .csv file and so we're needing to tinker with it a little.

Please see the attached. I want a new column to start where the row "# of 31 DOCUMENTS".

I would prefer to do it without doing a lot of cutting and pasting. . .HELP!

Test.xlsx

Hi CATTX01,
try this

Please Login or Register  to view this content.

Thank you!