Hi Guys,
Ive been trying to convert some data that come out of a SharePoint Survey, its not the nicest and looks like this:
;#Answer 1;#Answer 2;#Answer 3;#
I would like a cross tab query that has a row header for each value between ";#" and then count them
e.g. if there are 2 lines of...