How to split one Row into multiple rows

[Vinod]

Hi All.

How to split data into multiple rows based on the input data.

Can anyone help me on this.

I have attached sample data set for your reference(Refer Sheet1 for Input data and Sheet2 for Excepted ouput). 

Regards,

Vinod

[Vegar]

You can use Subfield () for this.

Load SubField([Numbers], ' ')  as Number

From Excel

[Vinod]

Hi sir.

It's not working.