Results 1 to 3 of 3

Thread: Pivot table data in column format

  1. #1

    Pivot table data in column format

    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator JoePublic's Avatar
    Join Date
    Sep 2011
    Excel Version
    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'.
    This website wants to know your momentum - | Deny | | Allow |

  3. #3
    Many thanks dear, it's resolved now, best regards,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts