Related Fields Text to Columns

[zcurt]

Hi,
I have a dataset that contains two related fields, but each cell could contain multiple values separated with "**". The position of the data within the two fields need to correspond with each other. I have had no luck separating without getting erroneous results included in my results. 

Thanks in advance!

Dataset

Cust ID	Alt_ID_Type	Alt_ID_Value
U-123	Cust#**Account#**System#	3333**AB4444**YZ9999
U-234	Hierarchy#	UU1234
U-444	AccountID	4444**BC2222

Desired Output

Cust ID	Alt_ID_Type	Alt_ID_Value
U-123	Cust#	3333
U-123	Account#	AB4444
U-123	System#	YZ9999
U-234	Hierarchy#	UU1234
U-444	AccountID	4444
U-444	AccountID	BC2222

[Felipe_Ribeir0 · Accepted solution]

Hi @zcurt 

One way of doing this:

If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

Thanks.

[binuacs]

@zcurt One way of doing this

[Felipe_Ribeir0]

Hi @zcurt 

It worked? If yes, please accept it as a solution. Thanks!

[zcurt]

Thank you, Felipe and binuacs! Both solutions were very helpful.