All you need to do is add a filter. Firstly make sure there is a single cell gab at the top of your spreadsheet. This has to either be a gap or a header, for example "store" In the 'store' column click the colum letter (ie A). That will highlight the whole column. In the "DATA" tab select...
You can obviously re-order it to seperate the list by Stores.
Just highlight the whole field of data and sort by A to Z.
Alternately you add an "if" formula to say something like "IF A3=jims shop, then show B3".
drag that formula all the way down and then it should just grab all the...