[h=3]I have an Excel sheet which contains the following parameters: [/h][FONT="]1. Country[/FONT]
[FONT="]2.State[/FONT]
[FONT="]3.Site[/FONT]
[FONT="]4. Shifts[/FONT]
[FONT="]5.Experience [/FONT]
[FONT="]I have another sheet in which I have the following [/FONT]
[FONT="]1. Country[/FONT]
[FONT="]2. State[/FONT]
[FONT="]3. Site[/FONT]
[FONT="]4. Vertical [/FONT]
[FONT="]I want a seperate Excel Sheet which contains the following columns:[/FONT]
[FONT="]1. Country[/FONT]
[FONT="]2. State[/FONT]
[FONT="]3. Site[/FONT]
[FONT="]4. Vertical[/FONT]
[FONT="]5. Shift[/FONT]
[FONT="]6. Experience [/FONT]
[FONT="]How do I go about this? Every site has a unique vertical and every state has multiple sites[/FONT]
[FONT="]2.State[/FONT]
[FONT="]3.Site[/FONT]
[FONT="]4. Shifts[/FONT]
[FONT="]5.Experience [/FONT]
[FONT="]I have another sheet in which I have the following [/FONT]
[FONT="]1. Country[/FONT]
[FONT="]2. State[/FONT]
[FONT="]3. Site[/FONT]
[FONT="]4. Vertical [/FONT]
[FONT="]I want a seperate Excel Sheet which contains the following columns:[/FONT]
[FONT="]1. Country[/FONT]
[FONT="]2. State[/FONT]
[FONT="]3. Site[/FONT]
[FONT="]4. Vertical[/FONT]
[FONT="]5. Shift[/FONT]
[FONT="]6. Experience [/FONT]
[FONT="]How do I go about this? Every site has a unique vertical and every state has multiple sites[/FONT]