Link to home
Start Free TrialLog in
Avatar of gixxer1020
gixxer1020Flag for United States of America

asked on

Transpose Data II

On the attached sample file, I need to flip the data from table 1 into the format of table 2.
I am finding that I am not able to use Transpose due to having some cells merged.
If possible I would like to have some VB code which I can insert into each sheet to accomplish this.

Thank you in advance

ssaqibh...I am unable to make this question private, sorry

Thank you,

Edwin
Sample-Table2.xlsx
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of gixxer1020

ASKER

Thank you....works like a charm

Edwin