data model issue

[#1]

I have database with following level of data.....

field1(id)    field2    field3      field4    field5  

123          1          Prod1    132      3477573

123         2          prod2     345      7657984

123         3         prod3       405     5947575

123          4         prod4       234   8749579

the user want to look data as

field1   (prod1's field2)       (prod2's field2)      (prod4's field2)    (prod2'sfield5)        (prod4'sfield5)

123           1                          2                         4                       7657984           8749579   

I have each Prod in different tables......field4 and field 5 are in one table.......here field1,field2 and field3 are in ID level and field4,field5 are in field2 level.......

so I am unable to represent data as user wish to see........