Search results

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...