Unpivot Data and Separate Integers and Strings in Power Bi

Question

This is the input table of the data 

and I want the desried output

As shown in the table,How can I do this by using Power Bi

Answer 1

Use the following measures

Value.Is([Column], Int64.Type)

Example, 
IsNumber =Value.Is(Value.FromText([ColumnOfMixedValues]), type number)

Value.Is([Column],type text)

Example, 

IsText =Value.Is(Value.FromText([ColumnOfMixedValues]), type text) 

if Value.Is(AlphaNumeric, type text) then AlphaNumeric else Number.ToText(AlphaNumeric))  

  If you wish to learn more about Power BI? Refer to Power BI Training