Hi, can any pro here help on this matter

eg
Transpose

BUS CARA CARB CARC
MV MV1 MV2 MV3 MV3

into
BUS CARA
BUS CARB
BUS CARC
MV MV1
MV MV2
MV MV3


Is there any ready make Marco that I could use to solve the problem? As example only a few data, but actual data will over 20,000 row.

Hope that some of the pro here can enlighten me. Thanks