Converting two column of data to proper tabular format

Asked Jul 23 '14 at 11:07

Active Jul 23 '14 at 12:49

Viewed 35 times

I'm having the data in format given below.

Col1  |  Col2
_______________
item1 | orange 
item2 | apple
item1 | guava
item2 | noodles
...

I want data to be in below format.

item1  |  item2
_______________
orange |  apple
guava  |  noodles
...

I'm using PostgreSQL 9.1.

Is it possible to do it in single SQL query?

edited Jul 23 '14 at 12:49

asked Jul 23 '14 at 11:07

Krishna

3

See http://stackoverflow.com/questions/tagged/postgresql+pivot – Craig Ringer Jul 23 '14 at 11:28
@krishna see this well explained [answer](http://stackoverflow.com/a/11751905/3682599) – Vivek S. Jul 23 '14 at 12:30
possible duplicate of [PostgreSQL Crosstab Query](http://stackoverflow.com/questions/3002499/postgresql-crosstab-query) – Konstantin V. Salikhov Jul 23 '14 at 12:49

0 Answers0