Multiple column to multiple rows

[qiyusi]

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.

[millz]

Assuming your data starts from row 1:

Please Login or Register  to view this content.

[jindon]

Alter Range("n1") to suite.

Please Login or Register  to view this content.

[qiyusi]

Hello,

Thank you for both reply and help.

tried the code.

Millz code perfectly works.

also tried jindon code, somehow not work properly and replace original list, i am not sure what is wrong, i just change n1 with a1.

anyway, thank you again. i think the problem solved.

[jindon]

What did you do?

[qiyusi]

i see! i change the n1 to a1, so it replace the list,

after check and tried your excel with code, it's working also !

probably i missed to add code, that i want to put the result in a1 in another sheet.

[qiyusi]

Just small question,

what if i want to do the same task, but the data string1-1, string 1-2,string 1-3 ( in the same cell but separate by comma) ?

[jindon]

Can you upload a workbook with what you have and what exactly you want for the result?

[qiyusi]

Thank you for your prompt reply.
here's previous file you have made, with small changes.
the string is in single cell.

also can you change the result to move to new sheet?
also when move to new row, the data in column B, keep the format as text. not number.

Appreciate for your help.

[jindon]

Change to

Please Login or Register  to view this content.