Cleaning Data

[sgaryali]

Hi

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?

[binuacs · Accepted solution]

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

Spoiler

[Qiu]

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

[Qiu]

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