Info from data set to a list

[olivergs1982]

Trying to find a way to get info from a data set into a list where by the list is populated only if a there is a figure next to a name for example:
Data Set:

Sue 0
Mark 16.99
Dave 0
Adam 0
Carl 2.45
Oliver 18.19
Kirsty 0

Which will populate a table with just those names and the totals greater than 0, so:

Mark 16.999
Carl 2.45
Oliver 18.49

Just can't seem to find the right question to ask for an answer or a formula that I think will work. Vlookups and If's were my initial thought though the data set is 200 row's long and the number of lines with numbers next to them that I'm trying to get into a list there will only ever be about 20 tops. I can't change my original Data set.

Any help would be gratefully received.

 

[James006]

Hello,

There are several possible solutions ...

The most efficient one is to Filter your source data ... in order to populate your List with the Visible Cells Only ...

Hope this will help

 

[olivergs1982]

How would I do that?

 

[James006]

How would I do that?

See this link for a clear explanation : https://www.excel-easy.com/examples/copy-visible-cells-only.html

Hope this will help

 

[olivergs1982]

Thanks, I've tried this though It's not doing what I want. Will ask again with more info and screen shots.