Generate output excel where format is exactly same as excel input file

PB41091

I have data like below:

Based on column G, there should be different excel files.

1. Arjun file with 3 entries, Chintan with 1 entry, Raj with 3 and Riaan with 1. (Basically, we need to split excel file as per names given in Column G)

the excel has colour coded cells, formatting and and also dropdown entries (for column E and F). I want everything as it is after splitting file.

				Input Data
A	B	C	D	E	F	G	H	J	K	L	M
123	James	Tier 3	N/A	<<Select>>	<<Select>>	Arjun	Arjun	-	533	-	4,205,311
21	Danu	Tier 5: <$1B	N/A	<<Select>>	<<Select>>	Arjun	Arjun	-	-	-	-
43	priya	Untiered	N/A	<<Select>>	<<Select>>	Arjun	N/A	-	-	-	-
543	payal	Tier 4	N/A	<<Select>>	<<Select>>	Chintan	Chintan	-	-	-	-
6775	prachi	Tier 4	N/A	<<Select>>	<<Select>>	Raj	N/A	-	-	-	-
788	suni	Tier 5: <$1B	N/A	<<Select>>	<<Select>>	Raj	Raj	3,358,956	527,239	-	104,637
976	shina	Untiered	N/A	<<Select>>	<<Select>>	Raj	Raj	-	10,065,595	-	-
234	john	Tier 5: <$1B	N/A	<<Select>>	<<Select>>	Riaan	Riaan	8,092,137	510,876	-	5,168,328

Gunnar-Scheck

Hi @PB41091,

I think this thread may have some useful information for creating a formatted output for you. 

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Formatting-Excel-Output-File/td-p/686734

You may need to create template files for each output and set up the output data tool to preserve the formatting on overwrite. However, some potential issues I can see with this approach is with the dropdown entries in column E and F, as well as if there are additional people that would need a separate output file. 

It may be helpful to provide a sample file of the type of formatting and color coded cells that are being used.