We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


from rows to columns — Vertica Forum

from rows to columns

bluepommebluepomme
in General Discussion

Hello guys, 

 

I want to convert A to B. 

 

ID question answer

1  name      John

1  age         23

2  name      Elias

2  age         67

3  name      Lionel

3  age         50

 

 

 

ID Name  Age

1  John    23

2  Elias    67

3  Lionel  50

 

 

Thanks for the help

 

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...