Forum Discussion
Excel outline that displays the entire row when expanded
ivotTables are great for taking large datasets and creating in-depth detail summaries.
Filter data in a range or table
Use AutoFilter or built-in comparison operators like "greater than" and “top 10” in Excel to show the data you want and hide the rest. Once you filter data in a range of cells or table, you can either reapply a filter to get up-to-date results, or clear a filter to redisplay all of the data.
Filter by using advanced criteria
If the data you want to filter requires complex criteria (such as Type = "Produce" OR Salesperson = "Davolio"), you can use the Advanced Filter dialog box.
Hope I could help you with these information / links.
I know I don't know anything (Socrates)
NikolinoDE Thanks, Nikolino, but I'm not trying to filter the data. I want to group it but show all columns of each row (like my example on the right). I can't find a way to make Pivot Tables (or Grouping/Outlining) do that.