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
    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 them to the Column box does not work. Bob

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!