Inserting data into table using select query

Question

Hi

 I have one table like
  Columsns

 ID(Primary key)    AP        MP      TN     MP      .....   These are all state names as columns


my query returning the data like 

 Statename       Count
 AP                     10
 MP                     20
TN                      30

How can i insert  this result set in to table in sql server.

Please help

Regards
Ajay