Properly convert data types in an unpivot statement

I have need to unpivot a table, with fields of varying data types, arranged like this:

Properly convert data types in an unpivot statement

I have need to unpivot a table, with fields of varying data types, arranged like this:

Properly convert data types in an unpivot statement

I have need to unpivot a table, with fields of varying data types, arranged like this: