Hii Guys ,
Please try to help me on this.
Existing data table like this:
part number | Issue id 1 | Issue id 2 | Issue id 3 | Issue id 4 | Issue id 5 | Issue id 6 | Issue id 7 | Ageing | created by |
---|---|---|---|---|---|---|---|---|---|
A | 1 | 2 | ranjith | ||||||
B | 11 | 12 | 13 | ram | |||||
C | 21 | 22 | 23 | 24 | sunil | ||||
D | 31 | 32 | 33 | 34 | 35 | sahoo | |||
E | 41 | 42 | 43 | 44 | 45 | aravid | |||
F | 51 | 52 | 53 | 54 | 55 | 56 | manju |
i need to add the data in Ageing column
ageing column data like this.
Ageing
6
5
5
3
9999
77
I want output like this.
part number | Issue id 1 | Issue id 2 | Issue id 3 | Issue id 4 | Issue id 5 | Issue id 6 | Issue id 7 | Ageing | created by |
---|---|---|---|---|---|---|---|---|---|
A | 1 | 2 | 6 | ranjith | |||||
B | 11 | 12 | 13 | 5 | ram | ||||
C | 21 | 22 | 23 | 24 | 5 | sunil | |||
D | 31 | 32 | 33 | 34 | 35 | 3 | sahoo | ||
E | 41 | 42 | 43 | 44 | 45 | 9999 | aravid | ||
F | 51 | 52 | 53 | 54 | 55 | 56 | 77 | manju |