Formatting a pivot table

  • Excel 2010 pulled external data from a Sage 100 inventory file. I have a pivot table with these items, Data is Product Line, Product Code, Pack, Sales


    Data looks like this in the report with first 3 fields in the row box and Sales in the Value box. Report has these items going down the page under each other in Column A


    Product Line
    Product Code
    Pack
    Sales
    All showing Column A


    I want the data to look like this


    Product Line Column A, Product code Column B, Pack Column C, Sales Column D


    How do I get them to go across the page and not up and down? I have a thousand item so moving the to the Column box does not work. Bob