macro to change rows to columns

I'm new to excel. I made a form in word that I wanted to import into excel. I end up having hundreds of these forms filled out but they are all in one word document with each form being one page.

When I try to import it into excel as a .txt file it imports fine but it is all on one row. Each form has 20 form values so I need to find a way to make a new row for every 20 columns. Can this be done with a macro, or do I have to cut this one word doc into 500 separate word docs?

Thanks