Transpose values in each row into the same column

Hi there,

I would like to turn worksheet "original" into worksheet "Output". As you can see, I'm basically just listing those test names separated by comma in each row vertically in the same column.

How can I do this with a click on a button? Just because the list is huge, users would like the idea of a macro.

I am relatively new to string manipulations in Excel, but would like some guidance.

Is anybody able to assist me on this?

Thank you