Populating Summary Sheet From Data Sheet

I know it's a way to do this. But I haven't been doing a lot of programming for the last 3 years. I have a data sheet that I want to summarize into the Summary Tab but I don't want to include line items on the summary tab that doesn't have a value. The data spreadsheet is going to at least 2000-5000 rows but not every line item will have a value to it so I would like to have the summary tab to only show the line items that has a value. I have a tab in the file attached called 'Summary Idea'. This is how I want the Summary tab to actually look. If anyone could help it would be GREAT!!!!

Hi jadown,
Find the attached, which I think is what you want.

Also could you please edit your post above and remove the Quote tags from around your text, so it is readable?

option 2, run code "test"