Transpose Data

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
Who is Participating?
Saqib Husain, SyedConnect With a Mentor EngineerCommented:

gixxer1020Author Commented:
Thank you,

This worked really well.  Unfortunately there has been a change in the table and now need a different format...I will post the next question privately to you for resolution

Thank you,

Saqib Husain, SyedEngineerCommented:
You can continue to post here or if it is significantly different then you can open a new question and post the link here so that I can see where it is.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.