Hi All,
I got a project Requirement where i need to Transpose nad summarize the data, I tried doing it in Pivot, i could not get the output.
Can this be done thru the VBA
Output
<tbody>
</tbody>
Input
<tbody>
</tbody>
I got a project Requirement where i need to Transpose nad summarize the data, I tried doing it in Pivot, i could not get the output.
Can this be done thru the VBA
Output
Risk/Complexity |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
Input
Project | Complex | Risk |
Project 1 | Easy | High |
Project 2 | difficult | Low |
Project 3 | Medium | High |
Project 4 | Easy | High |
Project 5 | Easy | Low |
Project 6 | difficult | Low |
Project 7 | difficult | Moderate |
Project 8 | difficult | Moderate |
Project 9 | Medium | Moderate |
<tbody>
</tbody>
Last edited: