cross tab problem

[luo]

Hi Everyone,

I am trying to make one column as column name and the other as value. But I don't know how to do it, the setting is not working. Thanks guys. 

Input:

Column1	Column2
a	1
a	2
a	3
b	1
b	2
c	1
c	2

Output:

a	b	c
1	1	1
2	2	2
3

[IraWatt]

Hey @luo,

Could you give the output you were wanting to see?

Thanks,

Ira

[PhilipMannering]

This works for your example. See attached...

[luo]

@IraWatt Hi, I did put the desired output above. Let me put down here:

a	b	c
1	1	1
2	2	2
3