Keep rows together in table

Hello Everyone, I was looking for some help with excel 2010. I have a time sheet that I want to make into a table. The thing is there are three rows (all next to each other) that I need banded together for every shorting option. So if my table starts on row 6 I would need row 7,8, and 9 to always stay together when shorting and also row 10, 11, and 12 to stay together and so on and so on. So basically I need the rows in groups of 3. I need this because of the data for different pay scales that can happen in the day. I appreciate any advice.

Thank you,
Paul

It's difficult to advise definitively without seeing an example workbook, but in a helper column you could introduce a sequence like 1.1, 1.2, 1.3, 2.1, 2.2, 2.3, 3.1, 3.2, 3.3 etc down the column so that if you include this within your sorting parameters then each block of 3 rows would be kept together.

Hope this helps.

Pete

I am not sure if the helper column will hurt attached is the spreadsheet. Basically each name section need to be lock to the 1, 1 1/2, and 2 scale that is to the left of it. Thank you for the help

And how do you want it sorted? By name, or by Job No, or by Total Hours?

Please explain more clearly what you want to do with these timesheets.

Pete

I would like to sort name and job name with the hours in the day columns staying attached to the name and job name. Most important is the name. I thought about listing the name and job name 3 times in every section but I would think there is an easier way. Thank you for the help Pete

Yes, it would be easier to list your names three times given the way you have set up your workbook.

Hope this helps.

Pete