Ok, under the gun timeframe wise so if anyone can help with I would appreciate it. Yes, this is the first time I have done a pivot table so hopefully this will be a easy question.
I have used the wizard to create the layout.
For the row I put the following two items:
Part Number (Column A)
Part Decription (Column B)
For the Data I out the following items
Count for Part Number (Column A)(to show me how many rows have the same part number)
Sum of Part Quantity (Column C)
Sum of Total $ (Column D)
All the data shows up correctly, however it shows each of the DATA items on a seperate row. I need to change it to show the DATA in Columns.
Meaning it shows my data vertically when I want to show it horizontally.
Hope this makes sense!
Thanks in advance!
I have used the wizard to create the layout.
For the row I put the following two items:
Part Number (Column A)
Part Decription (Column B)
For the Data I out the following items
Count for Part Number (Column A)(to show me how many rows have the same part number)
Sum of Part Quantity (Column C)
Sum of Total $ (Column D)
All the data shows up correctly, however it shows each of the DATA items on a seperate row. I need to change it to show the DATA in Columns.
Meaning it shows my data vertically when I want to show it horizontally.
Hope this makes sense!
Thanks in advance!