VBA - Spliting data in rows macro

[Jakub]

Hi Guys,

I'm a total newbie in VBA and I'm facing the following problem.

I have two columns arranged like presneted below.

Column A Column B
data a x1,y2,z3 ... xyz..
data b x1,y2,z3 ... xyz..
data c x1,y2,z3 ... xyz..

What I want to do is to have a macro that will split the data in column A & B in 1-1 relation. So the final output should be following:

Column A Column B
data a x1
data a y2
data a z3

etc.

Do you have any macro that would solve this issue of mine?

 

[Somendra Misra]

Hi,

See the file. It has Macro, data on Sheet 1 and o/p on Sheet 2.

Regards,

 

[Jakub]

Hi Somendra,

Thank you very much for swift reply. Maybe I wasn't specific egnough. There are only two columns. First contains only one vareiable second can have many separted by ";". How much I will need to change posted macro to aling it to the presented issue?

Regards,
Kuba

 

[Somendra Misra]

@Jakub

See this file, it don't have a clear function.

Regards,

 

[Jakub]

Thank you very much thats sloving the issue.

Regards,
Kuba

 

[Somendra Misra]

You are Welcome!!!

Regards,