How to split rows into multiple groups by specifis sub groups with main table header

[acaryasin01]

Hi Guys,

I have a table like below. This table is just example, so it could be change by size or number of the groups.

I would like to have sub groups based on email addresses with main table header. But I don't want to use multiple filter tool.

Here is my table and below that desired tables.

Any help would be appreciate 🙏🙏🙏

Thanks in advance,,,

Team Name	Team Email	Application	Notes
Team A	a@a.com	App 1	Lorem Ipsum 12345
Team A	a@a.com	App 2	Lorem Ipsum 12345
Team A	a@a.com	App 3	Lorem Ipsum 12345
Team B	b@b.com	App 4	Lorem Ipsum 12345
Team B	b@b.com	App 5	Lorem Ipsum 12345
Team C	c@c.com	App 6	Lorem Ipsum 12345
Team E	e@e.com	App 8	Lorem Ipsum 12345
Team E	e@e.com	App 9	Lorem Ipsum 12345
Team Name	Team Email	Application	Notes
Team A	a@a.com	App 1	Lorem Ipsum 12345
Team A	a@a.com	App 2	Lorem Ipsum 12345
Team A	a@a.com	App 3	Lorem Ipsum 12345
Team Name	Team Email	Application	Notes
Team B	b@b.com	App 4	Lorem Ipsum 12345
Team B	b@b.com	App 5	Lorem Ipsum 12345
Team Name	Team Email	Application	Notes
Team C	c@c.com	App 6	Lorem Ipsum 12345
Team Name	Team Email	Application	Notes
Team E	e@e.com	App 8	Lorem Ipsum 12345
Team E	e@e.com	App 9	Lorem Ipsum 12345

[atcodedog05 · Accepted solution]

Hi @acaryasin01 

You can use reporting tool to get output like below with grouping by on email column.

Workflow:

Resource learning material: https://community.alteryx.com/t5/Interactive-Lessons/tkb-p/interactive-lessons/label-name/Reporting%... 

Hope this helps : )

[acaryasin01]

Great 👌👌👌 

it works.

Thank you @atcodedog05 

KR,

[atcodedog05]

Happy to help : ) @acaryasin01 

Cheers and have a nice day!