query the data contain key value

[tkg_cangkul]

Hi, i have data sample to index it into solr.
below is the format of my sample data :
id,field1,field2
1,eventA=2,eventC=3
2,eventB=1,eventA=1

how can i query or indexing that data format in solr to get the result 
like this :

id,eventA,eventB,eventC
1,2,null,3
2,1,1,null

is there any way to do that?

pls help