Hi all.
I have a datagridview filled form a datab in access.It comprises of five fields.The database is a student database the fields are
number name exam score overall score. and they are presented like this
1 angie simms history 92 123
2 angie simms math 92 123
3 angie simms english 67 114
4 angie simms science 72 128
1 andy davies science 67 104
2 andy davies math 81 111
3 andy davies history 56 98
1 dave baker geog 82 114
2 dave baker history 82 114
3 dave baker math 82 114
4 dave baker english 82 114
5 dave baker science 82 114
6 dave baker french 82 114

Notice in column 1 each student record has their own record numbers
and these can vary from 2 upto 12.So in the above eg angie has 4 records,andy 3 and dave 6.What I wanted to do is create an empty row between each student record ,and I assume that there would have to be a loop involved which would take its cue from the first column of numbers for each student.So the above would then look like this.

1 angie simms history 92 123
2 angie simms math 92 123
3 angie simms english 67 114
4 angie simms science 72 128
empty row
1 andy davies science 67 104
2 andy davies math 81 111
3 andy davies history 56 98
empty row
1 dave baker geog 82 114
2 dave baker history 82 114
3 dave baker math 82 114
4 dave baker english 82 114
5 dave baker science 82 114
6 dave baker french 82 114
I can do this in excel but am baffled as to how to do it in vb.net.Any suggestions most welcome
regards
lilmelight