dynamic attribute transpose row to column

Question

i have dynamic attribute table one table is main asset_id table which contain 5 fix field

and another one is asset_Attribute which containt 3 col but

asset_id 
attritbute_name
attribute_value

which has a facility to add dynamic col and its value

asset_id table 

asset_id    city        state    country   Sex
  1        New York    New York   Us        Male

asset_attribute 
             Dynamic attribute   Dynamic attribute's value 
asset_id      Attribute_name       Attribute_value
   1             App_id               254b               
   1             App_name             java

so i want result like this

asset_id  city     state      country sex   App_id App_name
     1    Newyork  New york   U.s      Male  254b    java