Hi All,

I have a spreadsheet for logging hours worked, these are broken down into 5 categories which are placed beside each employees name, which is in column A and is a merged cell, row 2 to 6. (the 5 pay categories are in row 2 to 6, column B)

When I filter it by name it only shows the top row of every 5 rows, I added some pictures to try make sense of this

Without a Filter it looks like this (this is an example, my list is hundreds of rows long)
No Filter.jpg

When I filter it I get this, but what I want is for it to look like the above when filtered, to capture everything beside the employee name
No Filter.jpg

I hope this makes sense, not the best example, you can imagine if i had 100 employees and filter them all and they return as the second picture, Im not seeing all the information and so is of no use

any help on this issue greatly appreciated

Regards,