Excel Formula for Transposing

hi all,

thanks for having a look at my problem.

below is what I have in an excel

Vendor 1 Elec Mech IT
Vendor 2 Mech Elec
Vendor 3 IT Elec

This is what I want to achieve. can someone help me with this formula please.

Vendor 1 Elec
Vendor 2 Elec
Vendor 3 Elec
Vendor 1 Mech
Vendor 2 Mech
Vendor 1 IT
Vendor 3 IT

the original count of column is 12 here I only showed 3 as an example.

Thanks