set nocount on
if object_id('tempdb..#t') is not null drop table #t
create table #t([id] [bigint] IDENTITY ( 1 ,  1 ) NOT NULL ,
[c_id] [int] NOT NULL ,
[r_id] [int] NOT NULL ,
[f_id] [int] NOT NULL ,
[value] [sql_variant] NOT NULL)

insert #t values( 1 , 1 , 1 , 'a')
insert #t values( 1 , 1 , 2 , 'b')
insert #t values( 1 , 2 , 1 , 'c')
insert #t values( 1 , 2 , 2 , 'd')

select [table].c_id AS table_id, [row].r_id AS row_id, [field].f_id AS field_id, [field].value AS field_value
from (select distinct c_id from #t) as [table]
inner join (select distinct c_id, r_id from #t) [row] on [row].c_id = [table].c_id
inner join (select distinct c_id, r_id, f_id, value from #t) [field] on [field].c_id = [row].c_id and [field].r_id = [row].r_id
for xml auto