I have a spreadsheet that contains Part Numbers and Supplier Data and other
information. The data is in the following format:
Col A Col B Col C:?
Part # Supplier Other Information in Rows c:? Could be aa or ZA
123 ABC
123 DEF
123 GHI
456 ABC
456 DEF

I would like to merge the data to look like this:

Col A Col B Other INformation C:?
123
ABC
DEF
GHI
456
ABC
DEF

One Part number may have 1 suppliers or 100 suppliers. The data in Col C:?
is supplier specific so it would need to remain on the same row as the
supplier. Any help would be greatly appreciated.