Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a file with data like,
input data:
Manager | Chief | |||||||
Name | Start Date | City | Jan-17 | Feb-17 | Mar-17 | Jan-17 | Feb-17 | Mar-17 |
A | 1/1/2017 | Chennai | 5 | 6 | 7 | 8 | 9 | 5 |
Trichy | 4 | 24 | 3 | 2 | 4 | 6 | ||
Madurai | 5 | 6 | 7 | 8 | 8 | 9 |
I need the above table as below format,
Name | Start Date | City | Position | MonthYr | Value |
A | 1/1/2017 | Chennai | Manager | Jan-17 | 5 |
A | 1/1/2017 | Chennai | Manager | Feb-17 | 6 |
A | 1/1/2017 | Chennai | Manager | Mar-17 | 7 |
A | 1/1/2017 | Trichy | Manager | Jan-17 | 4 |
A | 1/1/2017 | Trichy | Manager | Feb-17 | 24 |
A | 1/1/2017 | Trichy | Manager | Mar-17 | 3 |
A | 1/1/2017 | Madurai | Manager | Jan-17 | 5 |
A | 1/1/2017 | Madurai | Manager | Feb-17 | 6 |
A | 1/1/2017 | Madurai | Manager | Mar-17 | 7 |
A | 1/1/2017 | Chennai | Chief | Jan-17 | 8 |
A | 1/1/2017 | Chennai | Chief | Feb-17 | 9 |
A | 1/1/2017 | Chennai | Chief | Mar-17 | 5 |
A | 1/1/2017 | Trichy | Chief | Jan-17 | 2 |
A | 1/1/2017 | Trichy | Chief | Feb-17 | 4 |
A | 1/1/2017 | Trichy | Chief | Mar-17 | 6 |
A | 1/1/2017 | Madurai | Chief | Jan-17 | 8 |
A | 1/1/2017 | Madurai | Chief | Feb-17 | 8 |
A | 1/1/2017 | Madurai | Chief | Mar-17 | 9 |
How can i achieve this??
Help me.
Here i attached sample excel file.
Try to load data in different table
1. First for the Manager with cross table.
2. Second with the Chief and concatenate this tables.
The only option is this.I don't think we can work around with second ways