Multiple rows to single rows

Hello

I have questions,

I have code to transpose multiple rows into single rows, it not 100% work,

Please Login or Register  to view this content.

as there are at least two problem:
1. the result is in single cell separate by comma, i need the result in separate column
2. the last data not show properly, in example, the letter G is not show up.

Would be great if you can review what's wrong with the code.

sample file attached.

Thank you for the help.

Hi !

Originally Posted by qiyusi

1. the result is in single cell separate by comma,
i need the result in separate column

Just use TextToColumns method as explained in VBA inner help …