Pivot Table...

[MK_QSL]

I have Customer vs Sales File.. where don't have any sales in Week 03...

My objective is to show

1) Customer vs Sales Data Weekly for All German Customers

2) Even though Week 03 is missing, I want to show week3 sales as 0 for A and B

3) The last null value rows should be removed...

File enclosed for your reference....

[MK_QSL]

anyone pls?