Pivot table data in column format

arkath

New member
Joined
Nov 28, 2013
Messages
2
Reaction score
0
Points
0
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

Super Moderator
Staff member
Joined
Sep 16, 2011
Messages
221
Reaction score
0
Points
16
Location
UK
Excel Version(s)
2016
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

New member
Joined
Nov 28, 2013
Messages
2
Reaction score
0
Points
0
Many thanks dear, it's resolved now, best regards,
 
Top