Hi,

If I have a excel 2003 file with a few rows/columns as follows

1234B,AB900,1
1234B,AB900,1
1244A,AB901,1
1267B,AB906,2
1279B,AB915,1
1279B,AB915,3
1279B,AB915,1
1288A,AB922,2

Can it be changed to the following using VBA?

1234B,AB900,1
1234B,AB900,1


1244A,AB901,1


1267B,AB906,2


1279B,AB915,1
1279B,AB915,3
1279B,AB915,1


1288A,AB922,2

Thanks for any help,

David