D
dyoung66
Hello,
I was hoping someone could help me with a problem I've been stuck on
for a while.
I have a file like so:
ID1 lName1 fName1 subj1 subj2 subj3
ID2 lName2 fName2 subj1 subj2 subj3
ID3 lName3 fName3 subj1 subj2 subj3
(etc)
that I need to convert to:
ID1 lName1 fName1 subj1
ID1 lName1 fName1 subj2
ID1 lName1 fName1 subj3
ID2 lName2 fName2 subj1
ID2 lName2 fName2 subj2
ID2 lName2 fName2 subj3
ID3 lName3 fName3 subj1
ID3 lName3 fName3 subj2
ID3 lName3 fName3 subj3
I can transpose easily enough, but I cant keep the first 3 fields
intact and repeat them for every row. (There are over 1000 rows in the
file)
Does anyone have any suggestions?
Thanks,
Damien.
I was hoping someone could help me with a problem I've been stuck on
for a while.
I have a file like so:
ID1 lName1 fName1 subj1 subj2 subj3
ID2 lName2 fName2 subj1 subj2 subj3
ID3 lName3 fName3 subj1 subj2 subj3
(etc)
that I need to convert to:
ID1 lName1 fName1 subj1
ID1 lName1 fName1 subj2
ID1 lName1 fName1 subj3
ID2 lName2 fName2 subj1
ID2 lName2 fName2 subj2
ID2 lName2 fName2 subj3
ID3 lName3 fName3 subj1
ID3 lName3 fName3 subj2
ID3 lName3 fName3 subj3
I can transpose easily enough, but I cant keep the first 3 fields
intact and repeat them for every row. (There are over 1000 rows in the
file)
Does anyone have any suggestions?
Thanks,
Damien.