Split column data into unique columns based on its datatype and populate column with Value data.

Use Table.Pivot to pivot the Type column, with Type as the Attribute and the Value column as the Values. Choose do not aggregate.

--Nate

Follow the below steps

select column type , from transform tab, pick add prefix from the format comand and write "Type" as value in the oppened window to reach the next image

then select type column and go to the transform tab and pick pivot command and provide the next setting

then press ok to reach your desired table as