I don;t know if this is asking to much from excel.
But, is there a way to do a paste special for my excel concern?
Please see attached sample.
Is it possible that Sheet 1(Orig Data)
will look like Sheet 2(Is this Possible)
Paste Special - Tranpose doesn't work, so maybe a VBA code will be able to solve this problem.
Thanks! I appreciate all your help.