How to split the column by delimeter and converted into row?

[Anonymous]

Hi

My original data is below,

Name	Category
Test	aa; bb; cc; dd
Test1	aa; cc
Test2	cc; aa;dd
Test3	aa;bb;cc
Test4	aa
Test5	dd
Test6	dd;aa

I want to split the category and create a new row for each respective name like below format

Name	Category
Test	aa
Test	bb
Test	cc
Test	dd
Test1	aa
Test1	cc
Test2	cc
Test2	aa
Test2	dd
Test3	aa
Test3	bb
Test3	cc
Test4	aa
Test5	dd
Test6	dd
Test6	aa

I tried in Power Query but not successful. Any suggestions, please? 

[Anonymous · Accepted solution]

Sorry . I found the solution from another post. Delimeter by row. 

Thanks

Sorry for the inconvenience.