I have a spreadsheet set up as follows:
Leftmost column contains customer numbers all the way down
Columns 2-20 contain part numbers in row one with blank spaces below. The intent is for an X to be placed in each cell on the table to correspond to that customer number having purchased that part
I.E. Customer 555 is listed on the left in cell A2 and there is an X in cells D2, I2, and K2 to represent customer 555 purchasing those part numbers.
The other sheet (called Data) is set up as follows
Left column customer numbers
Right Column the part number that the customer bought
Each customer number could be repeated numerous times (data has more part numbers than those listed on the sheet) as could each part number.
I was hoping to find a formula for what I am seeking above rather than going through 5,000+ individual data points.
Thank you to anyone who has some advice to offer!
Leftmost column contains customer numbers all the way down
Columns 2-20 contain part numbers in row one with blank spaces below. The intent is for an X to be placed in each cell on the table to correspond to that customer number having purchased that part
I.E. Customer 555 is listed on the left in cell A2 and there is an X in cells D2, I2, and K2 to represent customer 555 purchasing those part numbers.
The other sheet (called Data) is set up as follows
Left column customer numbers
Right Column the part number that the customer bought
Each customer number could be repeated numerous times (data has more part numbers than those listed on the sheet) as could each part number.
I was hoping to find a formula for what I am seeking above rather than going through 5,000+ individual data points.
Thank you to anyone who has some advice to offer!