macro to change rows to columns

**faptronic** · 02-04-2011, 05:37 PM

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

**nimrod** · 02-04-2011, 05:57 PM

Have you tried using the pastespecial function "Transpose" ? It takes the selected rows and changes them to columns ... and visa/versa.

**faptronic** · 02-07-2011, 09:24 AM

Originally Posted by nimrod

Have you tried using the pastespecial function "Transpose" ? It takes the selected rows and changes them to columns ... and visa/versa.

I think I may have explained my problem poorly originally. My problem is I have only one long row that I want to change into several rows. I need every 20 cells in this one row to be on a new row. I'm stuck...

Thanks

**watersev** · 02-07-2011, 10:45 AM

posting txt file would be helpful

**faptronic** · 02-07-2011, 10:58 AM

This is an example of the form template I am using from word and the .txt. This example is just 3 pages and I need to import it into excel with each page being its own row.

I know I can just save one page at a time but i may have up to 1000+ pages eventually and to save each file individually would be a big hassle.

Every page has 20 form values. The particular word doc I'm trying to import atm is 84 pages. So that is 1680 cells occupied all in one row. I could scroll every 20 cells and cut n paste to the next row, but hopefully there is a better way.

Thanks