I have code that automatically generates data in the format listed below and I was wondering if Excel had the capability of reformatting it into a more useful format.
Is it possible to reformat data in this format:
website1 6/19/2013 638
website1 6/20/2013 342
website1 6/21/2013 123
website2 6/19/2013 434
website2 6/20/2013 442
website2 6/21/2013 543
into this automatically?
6/19/2013 6/20/2013 6/21/2013
website1 638 342 123
website2 434 442 543
For the sake of an answer as such:
With labels for your columns select your data array, Insert > Tables - PivotTable, PivotTable, choose whether into the same (as in example) or another (conventional) sheet and drag the fields into the boxes as shown in the Field List in the image:
If the totals are disconcerting their display can be suppressed.