Bring in a file, create new rows, and move data from original file to specific new rows...

[paulb1]

Hello,

I have a file with a bunch of fields in it.  I need a way to be able to create a new file with rows where I can assign transaction #s and then move my original fields into these new rows.

Sort of like this:

Original Data File:

TestDate  StudentName  Score1  Score 2  DOB  Zip  Classroom#  Teacher  StudentID  TeacherID  Subject  Test#

Output:

100.1  TestDate  StudentID  Score1  Score2  Test#

102.6  TestDate  Teacher  Classroom#  Subject

104.3  StudentID StudentName  DOB  Zip

Etc.

Etc.

Any guidance/direction is appreciated.

Pau;

[ivoller]

I'm really not sure that I understand the problem. Can you post sample inputs and outputs?

[paulb1 · Accepted solution]

Actually I was able to figure this out.  

Thanks