Splitting an Excel File by Column Values While Preserving Formatting

Question

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?

binu_acs · Accepted Answer

@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

binu_acs · Accepted Answer

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