Hi,

I have a multiple forms extracted into one file. I need to get these in
column format. here's an example of my extract which i have in excel.

A B C
D
1 Form1
2 Form1 Description
3 1234 1235 12929
29492
4
5 Form2
6 Form2 Description
7 29382 29392 39292
29191
8 adfjajs dadfad aadfadf
adfakdf

i'd like to get the first two rows of each form populated in columns E and F
and have them repeat until the next form comes up (Form 2), which is denoted
by a blank row. the file can have hundreds of form submissions

I apologize if this isn't 100% clear.

Use DataText to Columns and follow the prompts.

Regards,
Fred.

"jbgoodma" <u50614@uwe wrote in message news:9387c0f3091cf@uwe...
Hi,

I have a multiple forms extracted into one file. I need to get these in
column format. here's an example of my extract which i have in excel.

A B C
D
1 Form1
2 Form1 Description
3 1234 1235 12929
29492
4
5 Form2
6 Form2 Description
7 29382 29392 39292
29191
8 adfjajs dadfad aadfadf
adfakdf

i'd like to get the first two rows of each form populated in columns E and
F
and have them repeat until the next form comes up (Form 2), which is
denoted
by a blank row. the file can have hundreds of form submissions

I apologize if this isn't 100% clear.