Possible formula to assist with this?

[moonbuck]

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

[TABLE="width: 649"]
<tbody>[TR]
[TD]ID[/TD]
[TD]VENDOR_ID[/TD]
[TD]PART_NO[/TD]
[TD]COST[/TD]
[/TR]
[TR]
[TD]01011 68 74 OE[/TD]
[TD]PPI[/TD]
[TD]1011[/TD]
[TD]5.23[/TD]
[/TR]
[TR]
[TD]01011 68 74 OE[/TD]
[TD]IMC[/TD]
[TD]1011[/TD]
[TD]905.77[/TD]
[/TR]
[TR]
[TD]01011 68 74 OE[/TD]
[TD]HOUSEGHIA[/TD]
[TD]1011[/TD]
[TD]1.1[/TD]
[/TR]
</tbody>[/TABLE]


How I need it to look

[TABLE="width: 1335"]
<tbody>[TR]
[TD]ID[/TD]
[TD]Vendor_1 Name[/TD]
[TD]Vendor_1 Prt#[/TD]
[TD]Vendor_1 Cost[/TD]
[TD]Vendor_2 Name[/TD]
[TD]Vendor_2 Prt#[/TD]
[TD]Vendor_2 Cost[/TD]
[TD]Vendor_3 Name[/TD]
[TD]Vendor_3 Prt#[/TD]
[TD]Vendor_3 Cost[/TD]
[/TR]
[TR]
[TD]01011 68 74 OE[/TD]
[TD]PPI[/TD]
[TD]1011[/TD]
[TD]5.23[/TD]
[TD]IMC[/TD]
[TD]1011[/TD]
[TD]905.77[/TD]
[TD]HOUSEGHIA[/TD]
[TD]1011[/TD]
[TD]1.1[/TD]
[/TR]
</tbody>[/TABLE]

I appreciate any assistance. I am rather new to this.
Thanks</technical>

 

[PCRIDE]

You may want to try recording a macro. I don’t really see a different in your examples

 

[Rick Rothstein]

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.

Is your data sorted by IDs first and then Part_No second?

 

[moonbuck]

You may want to try recording a macro. I don’t really see a different in your examples

I am not familiar with how to record a macro.

 

[moonbuck]

it is just sorted by ID. I hope I explained the issue correctly. I find that it is sometimes difficult to explain what I am trying to accomplish when it comes to excel.
I was unsure how to get the example to show up visually as a spreadsheet instead if just text.

to clarify, "VENDOR_ID" has 3 options for the same "ID"
I need to show a single row for the "ID" and have the 3 different "VENDOR_ID"s each in their own columns. This applies to the "PART_NO" and "COST" accordingly.

It seems like there should be a way break these out with a formula.

Thanks

 

[moonbuck]

Is your data sorted by IDs first and then Part_No second?

it is just sorted by ID. I hope I explained the issue correctly. I find that it is sometimes difficult to explain what I am trying to accomplish when it comes to excel.
I was unsure how to get the example to show up visually as a spreadsheet instead if just text.


to clarify, "VENDOR_ID" has 3 options for the same "ID"
I need to show a single row for the "ID" and have the 3 different "VENDOR_ID"s each in their own columns. This applies to the "PART_NO" and "COST" accordingly.


It seems like there should be a way break these out with a formula.


Thanks