Thanks for both of you...

Ron Coderre your solution seems nice but I wasn't able to obtain the
same layout for the result table as for my actual data table...

Dave O your solution is nice too but too complicated, the main reason
why I want to add qtys and totals is to reduce the number of
lines...there is hundreds of clients and products on my sheet...if I
add lines for each products that the client didn't buy (with qty=0 and
total=0) I'll have more lines then I have now on my sheet...

I'll try again to obtain the exact layout that I need using pivot table
but if someone have another idea you're welcome :)


--
Pwel
------------------------------------------------------------------------
Pwel's Profile: http://www.excelforum.com/member.php...o&userid=26191
View this thread: http://www.excelforum.com/showthread...hreadid=395006