I have a file that is stored in a column type fashion, when I transpose the
the worksheet so it will be more database friendly, rows, I end up with
multiple serial numbers in columns to the right rather than down. Example

This is what I have now:

Part Nbr    Part Desc    Inv Loc    Date        Serial Nbr                   
12345    XYZ    New York    03/12/08    543    709    2889    2803    555
4321    ZZZ    New York    03/12/08    123    321    456    654       

This is what I want:
Part Nbr    Part Desc    Inv Loc    Date        Serial Nbr
12345    XYZ    New York    03/12/08    543
12345    XYZ    New York    03/12/08    709
12345    XYZ    New York    03/12/08    2889
12345    XYZ    New York    03/12/08    2803
12345    XYZ    New York    03/12/08    555
12345    XYZ    New York    03/12/08    2884
4321    ZZZ    New York    03/12/08    123
4321    ZZZ    New York    03/12/08    321
4321    ZZZ    New York    03/12/08    456
4321    ZZZ    New York    03/12/08    654
4321    ZZZ    New York    03/12/08    789
4321    ZZZ    New York    03/12/08    987

I have been fooling with some If statements with ActiveCell locations but I
keep getting stuck and can't work through it. Any suggestions? My approach is
too simple I think. I was going to insert a row paste the serial number in
the blank row and then data fill the rest in....... Need Help Please