Main information row with sub row

**swhitesell** · 10-26-2012, 12:10 PM

I have seen this in the past. However, as I mainly used Access, I didn't pay attention to how it was created. I have two sheets of data where a one-to-many relationship could be made. I would like to display both on the same sheet with a main row and a drill down capability for the data on the many side of the relationship. The one I saw, had the +/- buttons associated with grouping, but the hidden rows appeared with their own header. Attached is a sample work book with the data and a picture of how I'd like to see the information.
Any assistance in this would be appreciated.

example.PNG Test_example.xlsx

**mahju** · 10-27-2012, 11:24 AM

Hi

If you can combine both the table, try this.
Copy the child table under the main table
Sort on CustID and part
Apply subtotal command under data tab

See the result in attached

Regards

**swhitesell** · 10-29-2012, 12:36 PM

I thought of this one, the problem is the spreadsheets I'm actually using has 10 columns of data on the first sheet and the second has 14. There are only 2-3 columns with similiar data. I mainly wanted to see if it was still possible to pull in the second sheet as a subset of the first wher you don't see the second until you pull it up. This would be a great suggestion if I had less data to filter.