Multiple column to multiple rows

Hello,

I have a data in multiple rows and would like to transpose the data into multiple rows.

Still trying to figure out the right vba code to do the job.

in single row:

1. data1 string1 string1-2 string1-3

want the output

1. data1 string1
1. data1 string 1-2
1. data1 string 1-3

please find attached excel for more detail.

Appreciate for any help.

Thank you.