I have a pricing grid which has labels in column A, quantities in column B,
rates in column C, and total price in column D. There are about 60 rows.

Typically, the finished result only uses ~20 of the items. What is the best
way to show a summary in column G that list only the labels which have been
assigned quantities?

thanks in advance,

Andy