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>
</tbody>
How I need it to look
<tbody>
</tbody>
I appreciate any assistance. I am rather new to this.
Thanks</technical>
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
ID | VENDOR_ID | PART_NO | COST |
01011 68 74 OE | PPI | 1011 | 5.23 |
01011 68 74 OE | IMC | 1011 | 905.77 |
01011 68 74 OE | HOUSEGHIA | 1011 | 1.1 |
<tbody>
</tbody>
How I need it to look
ID | Vendor_1 Name | Vendor_1 Prt# | Vendor_1 Cost | Vendor_2 Name | Vendor_2 Prt# | Vendor_2 Cost | Vendor_3 Name | Vendor_3 Prt# | Vendor_3 Cost |
01011 68 74 OE | PPI | 1011 | 5.23 | IMC | 1011 | 905.77 | HOUSEGHIA | 1011 | 1.1 |
<tbody>
</tbody>
I appreciate any assistance. I am rather new to this.
Thanks</technical>