PDA

View Full Version : Pivot table data in column format



arkath
2013-11-28, 08:23 AM
Hi everyone, I am new in this forum and need your expert advise about pivot table. I need the pivot table data row by row format, means I have 3 columns 1. Supplier Name, Purchase Order and Amount, when I create the pivot table and dragging the fields the purchase order data appear below supplier Name. I would appreciate if anybody can advise me how to move the purchase order field in column B to get the data row by row. thanks in advance best regards

JoePublic
2013-11-28, 09:06 AM
Click somewhere in the pivot table then on the Design Tab of the PivotTable Tools group on the right side of the Ribbon, click the Report Layout dropdown and choose 'Show in Tabular Form'.

arkath
2013-11-28, 09:22 AM
Many thanks dear, it's resolved now, best regards,