Hi there,

I am having a strange situation... our client send me a file with following format...
MS Excel version is 2003


SNo Name OrderId
1 Jack Ord1
2 Ord22
3 Ord34
4 Jill Ord47
5 Ord51
6 Ord645
7 Jane Ord787
8 Ord809
........................
........................
........................

The output I required is as -

SNo Name OrderId
1 Jack Ord1
2 Jack Ord22
3 Jack Ord34
4 Jill Ord47
5 Jill Ord51
6 Jill Ord645
7 Jane Ord787
8 Jane Ord809
........................
........................
........................

Have a nice day
Regards
John