Hi all
I have the following input data that I need to be able to group them into Output PowerPivot 1 and Output PowerPivot 2. The below example is just a simplified version but I would have thousands of row and different column. Could you please help to suggest a method. Really thanks.,
Input:
<tbody>
</tbody><colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup>
Output PowerPivot1:
<tbody>
</tbody><colgroup><col><col><col></colgroup>
Output PowerPivot 2:
<tbody>
</tbody><colgroup><col><col><col></colgroup>
I have the following input data that I need to be able to group them into Output PowerPivot 1 and Output PowerPivot 2. The below example is just a simplified version but I would have thousands of row and different column. Could you please help to suggest a method. Really thanks.,
Input:
Date | OH Truck Canada | Revenue Truck Canada | OH Truck Brazil | Revenue Truck Brazil |
1-Oct-17 | 12 | $10,000 | 8 | $20,000 |
2-Oct-17 | 10 | $15,000 | 10 | $25,000 |
<tbody>
</tbody><colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup>
OH Truck | 1-Oct | 2-Oct |
Canada | 12 | 10 |
Brazil | 8 | 10 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>
Output PowerPivot 2:
Daily Revenue | 1-Oct | 2-Oct |
Canada | $10,000 | $20,000 |
Brazil | $15,000 | $25,000 |
<tbody>
</tbody><colgroup><col><col><col></colgroup>