Group output into seperate sheets in one Excel

[RCern]

I have two files that I am doing a lookup via a "Join" tool.  The issue that I am having is once I identify the customers in the join then after a unique tool, I want to export to one file and group the rows for each customer from the Unique tool into their own tab within the same file.  Should I try and figure out a macro to accomplish this?   I am good up to the Unique tool, but then I don't know how to get Alteryx to group each customer from the results into it's their own tab in excel. 

In the example attached, I would expect to see all rows for "123 Company" in its own tab, all rows for "ABC Company" in its own tab and all rows for "XYZ Company" in their own tab.

Any help you can provide would be tremendously helpful!

[abacon]

@RCern What you do is in the output data tool, you select the options I have shown and choose the column you want the sheet to be named.

[RCern]

But that changes the sheet name only right?  How do I get only the rows for that one company to appear on their own sheet?

[abacon · Accepted solution]

That will group the records together where the name is alike. Check this workflow out.

[RCern]

Thank you!   Learned something new!

[abacon]

Very helpful piece of the tool, glad to help!