Dear all,
I want to transform data and store in a table in this format.
Actually I want to change the Column names into records.

1337 ABC Safety Council C
1337 ABC Safety Council GI
1337 ABC Safety Council O
1337 ABC Safety Council IS
1337 ABC Safety Council HR
1337 ABC Safety Council H
1328 University of XYZ C
1328 University of XYZ GI
1328 University of XYZ O
1328 University of XYZ H
1324 ABC College C
1324 ABC College GI
1324 ABC College O
1324 ABC College IS
1324 ABC College H

Script for existing data is as below

-----SCRIPTS
CREATE TABLE [dbo].[Registration_Audit_Safety] (
[CID] [int] NULL ,
[Client] [nvarchar] (255) NULL ,
[C] [nvarchar] (255) NULL ,
[GI] [nvarchar] (255) NULL ,
[O] [nvarchar] (255) NULL ,
[CS] [nvarchar] (255) NULL ,
[IS] [nvarchar] (255) NULL ,
[HR] [nvarchar] (255) NULL ,
[H] [nvarchar] (255) NULL ,
[HC] [nvarchar] (255) NULL
)

insert into Registration_Audit_Safety values (1234, 'ABC Safety Council' ,
'Yes', 'Yes','Yes',null,'Yes','Yes','Yes',null)
insert into Registration_Audit_Safety values (5678, 'University of
XYZ','Yes','Yes','Yes',null,null,null,'Yes',null)
insert into Registration_Audit_Safety values (9123, 'ABC
College','Yes','Yes','Yes',null,'Yes',null,'Yes',n ull)


Thanks in advance
Kay