Create two Tabs From one Input File In Excel

[kal-tech]

I have one input file. I want to slice and dice the data from the input file to create an output file with two tabs as shown below:

(a) The first column in the output file should be an incremental number like 1, 2, 3, etc.
(b) The top row of the output file should have a fill color of yellow and a font color of blue.
(c) Freeze the top row of both tabs in the output file.

Looking for your advice and suggestions.

Input File

Code	Name	Type
FR123	Apple	Fruit
VG1956	Carrot	Vegetables
VG203	Onion	Vegetables
FR456	Grapes	Fruit

One Output File with two Tabs

Tab-1 - Fruit

#	Code	Name	Type
1	FR123	Apple	Fruit
2	FR456	Grapes	Fruit

Tab 2 - Vegetables

#	Code	Name	Type
1	VG1956	Carrot	Vegetables
2	VG203	Onion	Vegetables

[terry10]

@kal-tech 

Really simple to do! Use the Take File/Table Name from Field and pick your Type column.

If my reply help you, please marked as an accepted solution. Thank you!

[terry10]

To format the Excel sheet, you can use a blob template.

https://intersectionsandoverlaps.wordpress.com/2019/09/27/alteryx-excel-templates-with-blob-tools/

Also reposted here.

[kal-tech]

(a) The first column in the output file should be an incremental number like 1, 2, 3, etc.   - COMPLETED
(b) The top row of the output file should have a fill color of yellow and a font color of blue. - PENDING
(c) Freeze the top row of both tabs in the output file. - PENDING

[Raj]

@kal-tech 
Please find attached
mark done if solved

Regards
Raj

[kal-tech]

Raj - Yes, the top header row background and font color are working perfectly. Thank you very much. Is there a way to

(a) freeze the top header row

(b) add a filter in both tabs in the spreadsheet?