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