himalarohee
New Member
- Joined
- Mar 11, 2012
- Messages
- 19
Hi, I have a table which have been loaded into data model like:
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I have another one like
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
How can I create a third table like below, which takes split from one table and it applies to the other one to create like below?
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
2014 | 2015 | 2016 | |
A | 10 | 20 | 30 |
B | 10 | 15 | 25 |
C | 25 | 25 | 30 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
I have another one like
2014 | 2015 | 2016 | |
a | 0.5 | 0.6 | 0.7 |
b | 0.4 | 0.3 | 0.2 |
c | 0.1 | 0.1 | 0.1 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>
How can I create a third table like below, which takes split from one table and it applies to the other one to create like below?
2014 | 2015 | 2016 | |
A-a | 5 | 12 | 21 |
A-b | 4 | 6 | 6 |
A-c | 1 | 2 | 3 |
B-a | 5 | 9 | 17.5 |
B-b | 4 | 4.5 | 5 |
B-c | 1 | 1.5 | 2.5 |
C-a | 12.5 | 15 | 21 |
C-b | 10 | 7.5 | 6 |
C-c | 2.5 | 2.5 | 3 |
<colgroup><col width="64" span="4" style="width:48pt"> </colgroup><tbody>
</tbody>