Split out a colmun of dates to different columns?

[miz]

Hi I have a column of months that are separated by commas and I was wondering if there was a way to split them out like shown to have each month be in its appropriate column.

Any help is appreciated.

Thanks,

Matt

[Claje · Accepted solution]

Hi,

Take a look at the attached workflow.

I tried to include tool descriptions to explain everything I'm doing.

I'm using a macro here which is the CReW Ensure fields macro to make sure the September field is included.

Please let me know if you have any questions!