Macro to Transpose variable columns into rows

Hi All,

I have a data set, (obtained after using text to columns function) and it contains data in variable colums. I need a macro to convert these variable colums into multiple rows, but in a single column.

I have attached the file. The sheet "original set" is the data I have and the "desried set" is the data that I need.

Thank you!!