Just loading the data and creating a pivot table with two dimensions and 1 measure should do it Gowtham.
See the attached QVF file for an example (copy it to C:\Users\<user.name>\Documents\Qlik\Sense\Apps if you're in Qlik Sense Desktop to view it),
Sample.qvf 192.0 K
I see, well propably some extension could do it.
But a simple table won't have this "aggregation" factor your looking for, since it will get the different lines.
You could do some treatment on the table, so that the values for the same capital appear in the same row, like this:
Concat(State,', ') as Col1,
FirstValue(Capital) as Col2
Group by Capital;
Giving the "Field creation" table bellow: