I have a spreadsheet of customer orders that looks something like this:

Flowers.PNG

So, customer names down the side, available products across the top. Values indicate quantity of products purchased by the customer.

I want to generate a summary for each customer that excludes zero-quantity items. So something like:

Joe
kimberly-fern: 3
premium-combo-planter: 4
purple-impatiens: 6

Dave
premium-combo-planter: 4
white-impatiens: 4

Susan
premium-basket: 4

Carl
premium-basket: 4
red-impatiens: 4

...and so on. This is only a small sample; there are about 120 products, so filtering out the zero-quantity items is important to eliminate clutter.

Any suggestions?