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 |
