Pivot the Occupation column in OCCUPATIONS so that each Name is sorted alphabetically and displayed underneath its corresponding Occupation. The output should consist of four columns (Doctor, ...
CheckListItems CheckListItemId ItemName 1 name1 2 name2 3 name3 4 name4 5 name5 ... I can't seem to get the PIVOT syntax correct- it has to be dynamic as I don't know all the ItemNames (and there ...
This tutorial is in response to a question posed by reader Mr Tom Trainer, who asked on 1st August: "Can pivot tables be used to manipulate 3-D spreadsheets, (i.e. spreadsheets consisting of several ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback