Showing data as a column name

I have three tables. I called them as Table A,Table B,Table C. And I have desired view which I want to get.

Table A
Aid         RegNum  BID         Value
2CE7D0A7    2000000 D5981DFC    OFFCRO
9D3C13AA    2000000 C58566C5    YCH - from 
9DDB90C4    2000000 812E9E75    Y

Table B is connected to Table A by Table B's foreign key in Table A

Table B

BID             Label                               ColumnName              Order
D5981DFC        Offered/Change Role                 StatusChangeCode        0
C58566C5        Offered/Role Change Comments        StatusChangeComments    1
812E9E75        Assessed                            StatusChangeAssessed    2

Table C has foreign key in Table A as well. Reg Num. Reg num is primary key in Table C

Table C 

Name        Surname     RegNum
Etibar      Hasanov     2000000

As you see there are column's names which are datas in Table B

DesiredView
Name        Surname     RegNum      StatusChangeCode    StatusChangeComments    StatusChangeAssessed
Etibar      Hasanov     2000000     OFFCRO              YCH - from              Y