https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52453#M7328 Hi,  I've a requirement of creating a pivot table from a data stored into collection or excel. Does anybody knows it how to achieve this? Thu, 17 May 2018 16:39:00 GMT Anonymous 2018-05-17T16:39:00Z https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52453#M7328 Hi,  I've a requirement of creating a pivot table from a data stored into collection or excel. Does anybody knows it how to achieve this? Thu, 17 May 2018 16:39:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52453#M7328 Anonymous 2018-05-17T16:39:00Z https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52454#M7329 The simplest option is to manually create a template Excel file with 2 sheets, one containing the pivot and one for the data. Create the pivot manually with some test data and save the template. Then have BP open the template, overwrite in the data and save a copy of the file. The Excel VBO does not have any 'create pivot' actions, you would need to create them. And given that there are many settings to a pivot table, this would not be an easy job. Thu, 17 May 2018 20:12:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52454#M7329 John__Carter 2018-05-17T20:12:00Z https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52455#M7330 So for any process related to pivot, is it easier to just navigate on the Excel UI? Tue, 17 Jul 2018 18:51:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52455#M7330 LucyLu 2018-07-17T18:51:00Z https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52456#M7331 Probably not, although I have never tried. I think using a pre-made template is the easiest but that approach may not suit every project. Wed, 18 Jul 2018 07:40:00 GMT https://community.blueprism.com/t5/Product-Forum/How-to-create-a-pivot-table-from-collection-data-or-excel-s-data/m-p/52456#M7331 John__Carter 2018-07-18T07:40:00Z