Ok,
whats the full data?
You just want these as columns?
if(A='TASKS COMPLETED',' ') as [TASKS COMPLETED],
if(A='TASKS IN PROGRESS',' ') as [TASKS IN PROGRESS],
if(A='TASKS TO BEGIN NEXT WEEK',' ') as [TASKS TO BEGIN NEXT WEEK],
if(A='URGENT ISSUES',' ') as [URGENT ISSUES],
if(A='SELF ASSESSMENT & COMMENTS',' ') as [SELF ASSESSMENT & COMMENTS]
From.....
I couldn't make a single field in Cross Table and it seem here we are removing values from dimension and using it as a dimension.
to be honest what goes inside those columns is more important... and how you want to link...
Just creating columns can be done in quite a few ways but that's not the answer for this.
