Macro or function to copy cell B to multiple rows and then populate cell A2 onwards

[avaris79]

Hi All,

I am new to this forum and excel macro.
I have data in column A where it is a single value & in column B where it is multiple values separated by ";".
Is there a way, using macro or function, to convert column B to multiple rows, then copy values from A1 to A+n onwards? Refer to my attached pictures for reference.
Thank you.

 

[mohadin]

How about the Ubound(x) statement? In this case X = column B which is required to be split?

X is an array containing the split result of column B
So Ubound (x) number of element in the array X
Hope this clear the issue

 

[avaris79]

X is an array containing the split result of column B
So Ubound (x) number of element in the array X
Hope this clear the issue

Got it thanks.

 

[mohadin]

You are welcome and thank you for the feedback
Be happy