Is it possible to assign level (count for how many parts (months) it was broken for each ID),

303 6/27/13 8/11/13 45

||

\/

level

1 303 6/27/13 6/30/13 3

2 303 7/01/13 7/31/13 31

3 303 8/01/13 8/11/13 11

Tx again,

Jamie thansk for your post. I got you point, then I can do inpivot.

Best

mario