Splitting an Excel File by Column Values While Preserving Formatting

[PB41091]

I have an Excel file that contains various data, including color-coded cells, specific formatting, and dropdown entries in certain columns. I need to split this Excel file into multiple separate files based on the unique names found in a specific column (let's call it Column G). Each resulting file should contain all the entries corresponding to one unique name from Column G, and it is crucial that the original formatting, color coding, and dropdown entries are preserved in each of these new files. How can I achieve this using Alteryx?

[binuacs · Accepted solution]

@PB41091 you can split the data into multiple separate files based on a specific column but you cannot keep the original formatting using alteryx. One option is to use the preformatted template and populate your data using blob tools

[PB41091]

@binuacs Can you share a sample workflow with template and blob tool usage

[binuacs · Accepted solution]

@PB41091 you can refer https://community.alteryx.com/t5/Engine-Works/The-Blob-Reporting-That-Isn-t-From-a-Horror-Film/ba-p/...