Sub-grouping solution needed

[cpbrehmer]

Does anyone know of a way to create an output that would have two levels of grouping? Group by Column 1 then by Column 2 with the data in Columns 3-6 displayed beside Column 2?

The data looks like this: 

Column 1	Column 2	Column 3	Column 4	Column 5	Column 6
Value 1	Name 1	5	9	8	0
Value 2	Name 1	3	9	3	2
Value 3	Name 1	12	13	10	0
Value 4	Name 1	18	3	2	0
Value 1	Name 2	5	9	8	0
Value 2	Name 2	3	9	3	2
Value 3	Name 2	12	13	10	0
Value 4	Name 2	18	3	2	0

But I would like the output to look like this:

Name 1	Column 3	Column 4	Column 5	Column 6
Value 1	5	9	8	0
Value 2	3	9	3	2
Value 3	12	13	10	0
Value 4	18	3	2	0
Name 2
Value 1	5	9	8	0
Value 2	3	9	3	2
Value 3	12	13	10	0
Value 4	18	3	2	0

Thanks!

[cbridges]

I belive all you would need to do is use a summary tool but group by Name prior to grouping by value. See if the attached accomplishes what you're looking for.

[jdunkerley79 · Accepted solution]

I would do this as a double summarise with a union and a bit of sorting and selecting

My sample with have the totals for the Name rows but these can easily be null'd out by removing the sums from the grouping.

[cpbrehmer]

Hi jdunkerlay79,

I was unable to open your example because you are in a newer version of designer. Is there a way you can export it and I can open it?

[jdunkerley79]

This one should work in 10.1 - I hope!

[cpbrehmer]

That did it. Thanks!