Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

convert multiple rows into multiple columns

Status
Not open for further replies.

pavikavi

Programmer
Oct 28, 2003
8
US
I need to convert rows of data into table of columns for example

id key val
1 A 11
1 B 12
2 A 22
2 B 33

i want

ID A B
1 11 22
2 22 33

Can any one help me out please

Thanks
pavithra
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top