Hi,
I'm using a program that feeds by this raw data that looks like this:
2019-05-13 09_22_55-Unique List from Source Data.xlsx - Saved.png
I wish to make a list where all information for one NCR number (11727 for instance), contains all supplier and part information linked to that column.
This would look something like this:
1.png
Thus far, I've been able to list one supplier and one part to each NCR no. What I'm having issues with is listing multiple parts to one NCR no. These are highlighted in blue.
See attached excel sheet for this problem sample, and with my attempt so far.
Bookmarks