Hello,
I have a table with thousands of rows, sample data below. I'd like to retrieve
ATTRIBUTE VALUE ID
Name Mark 1
Last_Name Holder 1
Age 21 1
Name Steve 3
Last_Name Johnson 3
Age 33 3
Name Peter 7
Last_Name Smith 7
Age 25 7
I'd like to select from this table but display data as per below, please point me to the right direction. I was thinking of an inline view.
Name Last_name Age
Mark Holder 21
Steve Johnson 33
Peter Smith 25
Regards,
P