How to freeze headers and Expand and Collapse row values

I need to freeze the headers (rows/ cols) and expand and collapse row values. which means, let say I have selected rows State and City. If I collapse State, Then City should disappear.