Hi. I have Office Professional 2013, Excel Version: 15.0.4693.1002. This is what I want to do:<o:p></o:p>

I have 7 Columns, 332 Rows. About half of those cells are "related". They are invoices, but our system displays them broken down by buildings. I need to show the Over All (or Original Invoice) info and still be able to expand that invoice line to see the exact breakdown. I also need to be able to do any sorting or filtering of the Original Invoices without the buildings from becoming separated. (Parent/children concept: Need to be able to shuffle the parents around but keep the associated kids with the right parents.)<o:p></o:p>

Below is what comes from an export document that I have set up. However I would like to be able to filter across all columns will having the lines stay together. (I.E. if I try to sort by line description, it will "Shuffle" all the Ref #s (these are the invoice numbers)). I could have sworn that you could "anchor" the cells (Quads) to a parent row (the one underlined) in a way so that when I do sort/filter by line description or price, it will not shuffle them around. *NOTE: GROUPING DOES NOT DO THIS! 

Entity	Ref #	Date	Date Created	Line Description	Amount	Created by
All Buildings - 1	87845	1/1/2014		1/14 LANDSCAPE PM	$4,854.00	ADMIN ADMIN
QUAD01				1/14 LANDSCAPE PM	$1,195.28	ADMIN ADMIN
QUAD02				1/14 LANDSCAPE PM	$844.99	ADMIN ADMIN
QUAD03				1/14 LANDSCAPE PM	$1,112.99	ADMIN ADMIN
QUAD05				1/14 LANDSCAPE PM	$483.12	ADMIN ADMIN
QUAD06				1/14 LANDSCAPE PM	$219.88	ADMIN ADMIN
QUAD07				1/14 LANDSCAPE PM	$468.41	ADMIN ADMIN
QUAD08				1/14 LANDSCAPE PM	$226.53	ADMIN ADMIN
QUAD09				1/14 LANDSCAPE PM	$302.80	ADMIN ADMIN

<o:p></o:p>

<o:p>Please let me know if I can explain this better.</o:p>

Hi Vickie_H,   Your best bet would be to make sure the empty cells are all filled with the associated invoice number. That way, filtering on the invoice number will keep them together. More so, you can use a pivottable to summarise them and use the grouping from there.   A quick trick to fill cells in data like yours is the following.   - Select a column which has empty rows like your data has - Press F5 (Goto), click "Special" - Select Blank cells - Click OK - Enter the equal sign and the up-arrow key - Press control+enter - Now select entire column, hit control+c - Hit control+alt+v and choose "Values" and click OK.