Extracting Unique Values when values are in one cell separated via Comma

[Masond3]

HI Team,

Hoping you can help me.

I have an excel which has two Columns;

ID : Column A
Account Code : Column B

ID	Account Code
2533642
1529358	341060
9380529	264672, 264690
	340230
570804	340290

What i would like to achieve is, for a given account Code (Column B) where the ID (Column A) is populated then provide me a unique row for every combination

NB: There can be multiple account codes associated to an Id, and these are separated out via a comma

Expected Result #

ID	Account Code
1529358	341060
9380529	264672
9380529	264690
570804	340290

Looking forward to your help 

[ChrisTX]

First use a Filter tool 

  IF !IsEmpty([ID])  AND !IsEmpty([Account Code]) THEN 1 ELSE 0 ENDIF

Then use a Text to Columns tool, split to rows, with delimiter comma.  Key field would be your ID field.

Chris

[mihaicom20]

Hello,

Maybe the flow attached can help you. The final result is like the one you wanted.

Regards

[Qiu · Accepted solution]

@Masond3 
Hope this would help