Power Query Mixed Data Type

[rsbin]

Good Afternoon,

Afer unpivoting my data source of hours worked, I have a column with both values and texts in the same column

Value

8

Regular

4

Overtime

Want to create 2 separate columns, one for "Hours" and the second for "PayCode"
After numerous attempts with Value.Is and Value.FromText, unable to get the syntax to work properly.
Hope someone can provide some guidance.
Thanks and Kind Regards,

[ryan_mayu · Accepted solution]

@rsbin 

pls see if this is what you want

[rsbin]

@ryan_mayu ,

Thank you!  Yes that is what I am looking for.

[ryan_mayu]

you are welcome