Grouping Rows by column Value...

Question

Hi, I did some extensive researches about this and couldn't find the way to do what I want...

It's pretty simple in Access when one makes a report to have grouping headers, but I want to stay in Excel for some reasons... the goal would be to have a table formatted with headers that would group lines based in a single column values.

I have explored the Pivot Table feature in Excel (I am quite familiar with it, but not an expert) and also the Microsoft Power Query for Excel add-in, but can't find the way to just show the original values of the lines grouped under a common header.

Pivot or Power Query propose to do some calculations (Sum, Counts, etc), but not only showing the original data of the lines that are assigned under the grouping.

Here is an example of what I want to do...

So If I add or modify values in my original Table, the table on the right (wanted end-result), would dynamically regroup the lines under the appropriate Header.

If you want another analogy of what I want to do, this kind of grouping exists in MS Outlook. For example, in OL, if you have the View option "Show in Groups" selected, the list of emails automatically have an header based on the Sorted Columns (here in this example, the emails are sorted by Date, and there is a grouping for "Today", "Yesterday", "Other days", "Last Week", and so on... like in the following example.

Hope it's just me that overlooked an option in the Pivot tables, or Power Query...

Thanks

Answer 1

Hi, look into Debra explanation and video on how to group in a Pivot

http://www.contextures.com/xlPivot07.html