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

[Farid_1]

Hello, I am sharing a small dataset on the left which I am struggling to achieve the desired output shown on the table to the right.  Can anyone assist?

 

[Anonymous · Accepted solution]

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

[Omid_Motamedise · Accepted solution]

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 

[Farid_1]

Nate,

That worked like magic!

THANK YOU!

Farid

[Anonymous · Accepted solution]

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

[lbendlin]

Don't do it.  Load the data as is and let the Matrix visual sort out the pivoting for you.