Divide an Excel file into multiple workbooks and sheets.

[JennyRuns24]

Hello,

I have an excel spreadsheet with a list of properties. In Alteryx, I'm attempting to create a new workbook for each unique property and a new sheet within that workbook for each Space ID. For example, in this screenshot, I want Alteryx to generate two Excel workbooks (ABC and DEF), with eight different sheets for each space ID in Workbook ABC and three sheets for the three space IDs in Workbook DEF. Excel sheet is attached. Can someone please help? Thank you!

[nagakavyasri · Accepted solution]

@JennyRuns24  try this

[JennyRuns24]

Thank you very much for your assistance! I'm wondering if there's a way to have the output generated in each sheet go from top to bottom rather than left to right?