How would I split the following row data on the items columns to get n-material rows? company_name items Company 1 item1, item2 into 2 rows company_name items Company 1 item1 Company_1 item2

[GowtamK]

Just wanted to know more on it.

Provided data:

company_name items

Company 1 item1, item2

Expected data:

company_name , items

Company 1 , item1, item2

Can we get the raw data as expected above? If it's yes, we can easly do the transfermation