Putting results on a single line

Hi,

I'm not sure how to do this...

I have included an example worksheet with my problem but what I wish to do is go down the left side (blue cells) entering quantities.

Then to the right, on a single "line" I would like only the cells with numbers in them to display how many of each type.

Example:
Books: Sci Fi 8, Horror 4, Art 6 etc.

I'm sorry if my above explanation isnt easy to follow, hopefully the included worksheet will be more helpful,

Rod

take a couple of steps.

put this formula in cell E12
=IF(D12<>"",C12&" "&D12&",","")
copy it down

hide this column if you like.

put this formula in I12
=CONCATENATE(E12,E13,E14,E15,E16,E17,E18,)

Matt