Cleaning Data

I want to separate only Night Shift from Column Leave type into new column.

I can do this by text to column tool but in few rows there are only two types of leave and in few three.

So this won't be the effective way to do this plus I don't know max number of leaves types in one row.

What are the other ways to achieve this?

Workflow

Accepted answers

@sgaryali Use RegEx parse to extract only the "Night Shift"

Spoiler

@sgaryali Use RegEx parse to extract only the "Night Shift"

Spoiler

@sgaryali
We cab first split to rows then do a crosstab. This will be dynamic

@sgaryali
Sorry, seems I misunderstood. this is the updated one.