Please help with a macro to tranfom the ff:
Column B1, C1 .... contains Job Role
Column B2, C2 .... contains Course Code
Row A3 ... contains UserID
B3 ... contains X indicating UserID has been assigned Job
Role B1 ans so on. The range may be set A1:T1000

A B C D E F G H
1 SD00:Display SD00:Product_MNG
2UserID SD 03 SD04
3IR_00783A x
4IR_01693B x


Must be tranformed to a new worksheet containing UserID
and Job Role

A B
1IR_00783A SD00:Display
2IR_01693B SD00:Product_MG