Hello, I have a two column table(an excerpts below), the first column is date while the second is activity. There are four different activities in the activity column (Aggregator click, Display click, Facebook click and Paid Search Click). Date Activity 30/08/2011 Facebook Click 05/08/2011 Display Click 28/08/2011 Paid search Click 29/08/2011 Display Click 29/08/2011 Display Click 28/08/2011 Aggregator Click 09/08/2011 Aggregator Click 08/08/2011 Aggregator Click 05/08/2011 Paid search Click 07/08/2011 Paid search Click 18/08/2011 Facebook Click 18/08/2011 Paid search Click 30/08/2011 Aggregator Click 03/08/2011 Paid search Click 08/08/2011 Display Click 08/08/2011 Display Click 08/08/2011 Paid search Click 08/08/2011 Facebook Click 08/08/2011 Facebook Click 08/08/2011 Paid search Click 08/08/2011 Paid search Click 08/08/2011 Paid search Click 08/08/2011 Paid search Click 08/08/2011 Paid search Click 10/08/2011 Aggregator Click 10/08/2011 Aggregator Click I will like to transform the table into five column table, where each activity is counted per day and return something in the nature of below example; Date Aggregator_click Display_Click Facebook_click Paid_search_click 03/08/2011 2 4 0 6 I will very much appreciate any help.
... View more