changing Rows to columns

[Sshasnk]

I have a dataset which is in row but I have to change that into columns 

Input: 

Name	Value
avg_height	1.93
avg_width	2.36
avg_length	2.23
avg_distance	1.23

Output:

avg_height	avg_width	avg_length	avg_distance
1.93	2.36	2.23	1.23

[AngelosPachis]

Hi @Sshasnk ,

A cross-tab tool should do that. Your column headers are in the [Name] field and your values in the [Value] field. You will have to then select a way to aggregate the data, but in this case it doesn't matter as you have unique entries for each new column. So selecting Sum or Avg shouldn't make any difference.

If you have multiple records you will need a way to differentiate between them so a column that will act as a unique identifier for each group of records, like shown below

Name	Value	ID
avg_height	1.93	1
avg_width	2.36	1
avg_length	2.23	1
avg_distance	1.23	1
avg_height	1.83	2
avg_width	2.26	2
avg_length	2.15	2
avg_distance	1.33	2

and you can use that ID field to group by in the cross-tab tool.

Cheers,

Angelos

[binuacs]

@Sshasnk as @AngelosPachis mentioned you can use the cross tab tool achieve the result