I need to have a list "flattened" <technical term?
Part IDS is column B contains different suppliers for parts in column A. Multiple suppliers need to be spread out into individual columns so there is a single part number in column A.
How it looks
<tbody>
ID
VENDOR_ID
PART_NO
COST
01011 68...