Text to Columns: Disaggregating data

Dear all,

I am sort of a noobie with Alteryx and was wondering if there is a simple way to use the Text To Columns plus RegExp to solve a probelm that I have.

I have in Column A account numbers, and in Column B Departments separated by ",". Is there a way to divide the departments by account? I was think something like /t /s in the Text to Column tool.

Thank you in advance for your time and cooperation.

Best,

jf97hernandez

Datasets

Accepted answers

Qiu

@jf97hernandez

If you prefer RegEx and I also show the sample introduced by @Emil_Kos , need a Clean Tool though.

0122-jf97hernandez.yxmd

All comments

Christine_Assaad

Hi @jf97hernandez

Will you be able to provide data sample to better help you? Thanks!

jf97hernandez

Christine,

Thank you for your response.

Here you go:

6282369	Air, Ocean, Ground
6281033	Air, Ocean
6281095	Air, Ground
6281096	Ocean, Ground

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703