当前位置: 动力学知识库 > 问答 > 编程问答 >

How do I re-arrange (auto-generated) data into another arrangement in Excel?

问题描述:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: