Help needed with transforming a column with two types of numeric values

[Anonymous]

Hello all!

Apologies if this has been covered before, but I could not find a suitable answer. I am transforming data in Power Query that relates to sick leave percentages and hours. In a query, I have a column that includes values for both. Is there a way to separate them quickly? A functionality that I have not thought of? There are five types of time events that include the aforementioned values: sickness hours, accident hours, theoretical hours, sick leave % and accident absence %. How to separate the numbers for sick leave % and accident absence % from the rest? 

Attached is a snapshot of the table so you get the idea. 

Cheers for your help and for this forum, 

Jani 

[AlexisOlson]

I'm not quite sure what you want the result to be after "separation".

If you want it to look something like this, then go with @HotChilli's suggestion:

If not, then you'll need to specify what the desired result should be.

[HotChilli · Accepted solution]

You could add a subcategory column with an if statement in Power Query, similar to 

if List.Contains({"sick leave", ...........},[event column....]) then "a" else "b")

then Pivot (from the Transform menu) the new subcategory column.

I've only given you some of the syntax for the column so you can complete it

[Anonymous]

Hello, 

Yes, thank you both for the help! I will go with @HotChilli s suggestion. 

All the best, 

Jani