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
Sample-Table.xlsx
gixxer1020Asked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Try

=IF(INDEX($C$4:$P$7,MATCH(IF(C$11="",B$11,C$11),$B$4:$B$7,0),MATCH($B12,$C$3:$P$3,0)+(C$11=""))="","",INDEX($C$4:$P$7,MATCH(IF(C$11="",B$11,C$11),$B$4:$B$7,0),MATCH($B12,$C$3:$P$3,0)+(C$11="")))
0
 
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,

Edwin
0
 
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.
0
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.