Finding multiple values and moving all row data associated to a preset place in new

Have data in one sheet assimilated by an advanced filter into 3 columns.

In my first sheet I have the 3 columns, 1st is a store #, then a position, then a job code. There are multiple store #'s (some with the same store #)with different positions and codes. What I need to do is have a function that will search for all stores, such as store # 1, then place the position and the job code of each one it finds for that store into a different sheet in a predetermined area. On this 2nd sheet, I have the store # listed (#1) followed by a column for the position and another for the job code. I have 10 rows dedicated for each store, for example, C3 to C12 is the store #, D3 to D12 is blank to be filled in by the position the lookup finds from the sorted data in the 1st sheet and E3 to E12 same for job code. Then C13 thru C22 starts the next store #, etc.

Any help would be appreciated. Thank you.

If you can SORT your first sheet, then the second sheet can display the needed rows with simple INDEX/MATCH formulas, no array formulas or VBA needed. Can you do that?

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.