how to create columns based out of cells

[Jayasree Atmakuru]

Hi , 

I am new to open refine please suggest me how to create new columns based out of data in column, 

Ex : i have Item and Desc. All distinct items should be created as columns with rows as values in Desc column, 

 In tabula format

Item	Desc
A	123
A	345
B	asfe
C	saas
B	sdda

to 

A	B	C
123	asfe	saas
345	sdda

Please help me , how to create column out of cells in open refine. 

regards,

Jayasree.A

[Owen Stephens]

I think you can use one of the 'Transpose' options for this:

Click drop down in one of the cols

Choose Transpose->Columnise by key/value columns

Select 'Item' as the Key Column

Select 'Desc' as the Value Column

Click OK

[Jayasree Atmakuru]

Thanks a lot for your reply.