I need a way to automate a merging of information of a group of cells in a column based on them having the same value in the adjacent column:
Basically I need this:
Part OEM CLS1001 OEM1 CLS1001 OEM2 CLS1002 OEM4 CLS1002 OEM5
To become this:
Part OEM CLS1001 OEM1/OEM2 CLS1002 OEM4/OEM5
There are many thousands of lines in the file, so any manual way seems impractical. Any help someone here can give me would be appreciated.
Bookmarks