dear Jeff

Thanks for the reply.

i did try the use of pivot table but that what i manage to get is for each customer deferment lines of each activity.
what i am looking for is a single line for each customer but with a split in the period for every activity.