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