问题描述:

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.

For example:

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.

相关阅读:
Top