Split text by delimiter

[JBATAIDE]

How do I split multiple columns to rows by a delimiter character?

Please find an example in attachment.

Thank you,

Joao

[MichalM]

@JBATAIDE 

Try the Text-to-columns tool in the Split to rows setting.

[Jonathan-Sherman · Accepted solution]

Hi @JBATAIDE.

Is this what you're looking to achieve?

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workbook for you to download if needed.

Regards,

Jonathan

[JBATAIDE]

Thanks I think it was helpful. But perhaps I was too simplistic.

Since it is a big dataset I don't know the exact number of delimiters per row (it may vary).

So I doesn't seem like it is working

E.g.

[MichalM]

@JBATAIDE 

To make this fully dynamic you will need to use the Transpose tool in combination with the Text-to-columns in the setting I suggested above - split to rows - where you don't need to specify how many columns in needs to be split into.

Example attached.

[Jonathan-Sherman]

@JBATAIDE I've updated the attachment to change to split to rows rather than columns for you.

[akorte1]

Thanks