how to create hierarchy to my data

[rish_sai]

‌hi all,

In my database i have cloumms like org1id, org2id,org3id,org4id

org1name,org2name,org3name,org4name, org1prod,org2prod,org3prod,org4prod

to above data client want see only orgid,orgname, orgprod

to above cloumns can anyone plz tell me how create hierarchy

Thanks in Adv