I have a table that i need normalized. I know how to convert it to pivot and normalize it that way but i would rather use vba because I have 2007 and i have to do extra steps in order to normalize it with excel 2007 pivot. if i had 2010 or newer, it would be simpler using pivot.
Attach is the sample summary table that needs to be normalized. I need two normalization.
If you can recommend an add-in, that would be a good solution, it would be much apprecaited but i am trying to learn as much vba as possible.
I apprecaite you all for your help. this forum is invaluable.
Attach is the sample summary table that needs to be normalized. I need two normalization.
- one specifically by PSR Name which is column C
- another specifically by LivingCenter which is column E
If you can recommend an add-in, that would be a good solution, it would be much apprecaited but i am trying to learn as much vba as possible.
I apprecaite you all for your help. this forum is invaluable.