make a sub table - only lines with X in column A

[johnandrews]

Hi all,

I have a table with all my data on it. Say, a list of fruit and the countries they are supplied from. I also want a smaller table listing all the fruit supplied from country X.

Where do I start? I'll try and get a sample uploaded.

Edit: sample uploaded.