How do I assign a value when rows header and column headers are matched in MS SQL 2012? : I have 400 columns and rows on my table.  They are exactly same string value, you can imagine this as a matrix. However, the index values are blank and need to assign a value where the column and row names are same. 

Example, 
                           RIGHT NOW
                 ## Column A ##, ## Column B ##
## Column A ##                        
## Column B ##         

                      OUTPUT SHOULD LIKE THIS
                 ## Column A ##, ## Column B ##
## Column A ##         6               10
## Column B ##         10              6

Can anybody help me get this output? 

SQL answers greatly appreciated if not Excel functions will also work.

Thanks in advance!




