Hi,
I am curious if it is possible to list the column field names next to the respective rows with the column field values, rather than on top of the rows with the column field values.
I’ve uploaded two prints to illustrate what I mean.
In the original_table I’ve selected “Item Type” and “Manufacturer” as column fields, and they are listed on top of the rows containing their items/members. However, in the desired_table I’ve they’re listed next to the rows.
I am not sure if this is even possible in Excel, but is it possible with Aspose.Cells?
Kind regards,
Daniel
Hi,
Hi,
Thank you for your reply.
I don’t really have any code that illustrates what I want to make. However, I’ve uploaded a workbook that has a pivot table I manage to create with Excel and a copy of that pivot table, but where the “Item Type” and “Manufacturer” header is next to “Ball” and “Asis” rather than above “Ball” and “Shoe” as in the actual pivot table. I am wondering if something like that is possible to do with a pivot table?
Alternatively we’ll write code to copy the contents of a pivot table and do it manually (by moving cell contents so it matches the desired look).
Kind regards,
Daniel
Hi,