You can use autofilter:

In A1 thru C7:

item value author
Concert 1 $0.00
Concert 2 $0.00
Concert 3 $75.00 3333
Concert 4 $0.00
Concert 5 $25.00 5555
Concert 6 $0.00

click on C1 and pull-down:
Data Filter AutoFilter

then using the C1 pull-down, select NonBlanks

You should see:


item value author
Concert 3 $75.00 3333
Concert 5 $25.00 5555


Then just copy and paste.
--
Gary''s Student - gsnu200735