Pivot table

gheyman

Well-known Member
Joined
Nov 14, 2005
Messages
1,844
Office Version
  1. 365
Platform
  1. Windows
I want to create a pivot table from my data. I have ItemID (Part Numbers going down one column and Suppliers going down another). The list has duplicate part numbers and duplicate suppliers (intentionally).

I would like a pivot table that shows the Part numbers going down a column and the all the vendors going across the header row where there is an indicator (maybe an "X" or anything) that shows if that suppler is listed for that part in that row. hope that makes sense. But I am not sure what to even research to figure out how to do this. The list of parts and suppliers are dynamic which is why I think I need a pivot table to do this. any suggestion on how to create this pivot table or other options is appreciated.
 

Excel Facts

Which Excel functions can ignore hidden rows?
The SUBTOTAL and AGGREGATE functions ignore hidden rows. AGGREGATE can also exclude error cells and more.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,286
Office Version
  1. 365
Platform
  1. Windows
All you need to do is put the ItemID in the Rows section, the SupplierID in the columns section and (Count of) ItemID in the Values section.
 
Solution

Watch MrExcel Video

Forum statistics

Threads
1,130,124
Messages
5,640,250
Members
417,131
Latest member
Seanr19871

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top