How to tune the below query

I am currently working on below table structure to pull the data/ generate any one time report.

Let us consider the table name to be ABC.

ID  Field   Value
1   Name    Nagarjuna
1   Gender  Male
1   Industry    Actor
2   Name    Sachin RT
2   Gender  Male
2   Industry    Sports
3   Name    Theresa
3   Gender  Female
3   Industry    Social Worker
4   Name    Saha
4   Gender  Female
4   Industry    Software Engineer
5   Name    Swe
5   Gender  Female
5   Industry    Doctor

In order to get the report in the format Name,gender,industry values, i am writing the below query

(Select 

vname.Value, vgender.value, vindustry.value

from ABC [vname] with (nolock) 

join ABC [vgender] with (nolock)
on vname.id = vgender.id

join ABC [vindustry] with (nolock)
on vgender.id = vindustry.id

where vname.field = 'Name' 
and vgender.field = 'Gender'
and vindustry.field = 'Industry')

I am currently working on the table which has around 5 lakhs of records and for each id type there would be around 10 - 30 entries, so if more records are there for one id type then more joins would be added up.

Because of this for executing its taking a lot of time.

Is there any way that we can reduce this time taken for execution and also this table is used by an website where there would be around 1000 to 50000 users.

I look forward in hearing from you.

Regards, Dev